Could someone help me with building an array for each row of the calculated value.

 

I have a set of 12 values that I get from using a formula @Expected 10% New. Now I want to store these values in a array and reference each of them separately in my details section. This is what I have done so far.

 

In my formula I have the following

 

WhilePrintingrecords;
global numbervar Array inv1Array;
redim preserve inv1Array [ubound(inv1Array)+1];
inv1Array [ubound(inv1Array)+1] := {@Expected 10% New};

 

In another formula I have the following to reference the first value in the array and I place this in the details section.

 

WhilePrintingrecords;
global numbervar Array inv1Array;
inv1array[1]

 

but I get an error saying "A subscript must be between 1 and the size of the array"

 

What am I doing wrong. Please help!

 

 

 

Thanks for your reply. But I am not sure how to modiy the formula still. When you aid use the ubound(inv1Array) in the assignment did you mean that I should not use redim preserve at all?

 

Thanks for your time.