Array value not passed to Calculation Formula Cross Tab

22 Views

Hi,

I have setup an array to collect summary information and placed this array formula in the Group Header Section of the report. I can see the values are being output correctly in the report as I can see them in the group header of the report.

I also created a new formula which picks up an array value and placed that in the group header and for the array item i selected it displays the correct value. However, if i place this formula in the page footer it shows zero.

Also, if i use this array item in the calculation formula in a cross tab it shows zero. The cross tab is in the page footer.

It is crucial for me to able to use this array item in the cross tab. I havent had issues with passing values to the calculation formula of the cross tab when it was a normal variable (not an array item)

Any ideas?

Thanks