I need to decalare a global array, but it doesn't seem to be able to maintain the inserted values. I assume that I'm not declaring it correctly. In the Formula Field where my calculation takes place, I say:
Global NumberVar Array x;
Redim x[24];
if PreviousIsNull({hrtables_Ent.n1}) then // Check for the first record
x[1] := {hrtables_Ent.n1} // Get the initial number (70,000)
else // On everythinig else
x[GroupNumber] := x[GroupNumber - 1] * 1.04 // iterate through the
// Group # (1 - 24 in this case)
// and multiply the previous #
// by 4 percent
It appears to give me the first number, but then zeros for the remainder. Does the declaration of the variable have to take place somewhere else? JPT
Edited by jpterry - 17 Oct 2012 at 11:08am