How to total a Calculated Member

[kat50]

I have created a calculated member based on my grand total (left) that I named Second Fee where I say

if (GridValueAt (CurrentRowIndex,CurrentColumnIndex -1 ,CurrentSummaryIndex)
>1 ) then 10 else 6

How can I get a total of this column("Second Fee")? When I right click on the summary it is telling me that the sum is on the value I used to create the grand total???

 

[IanWaterman]

YOu will have to use a global variable which is evaluated at the same point, place formula in same location and suppress so not visible.

@Secoondfeetot

global numbervar secfeetot eval;

if (GridValueAt (CurrentRowIndex,CurrentColumnIndex -1 ,CurrentSummaryIndex)
>1 ) then secfeetot:= secfeetot+10 else secfeetot:= secfeetot+6

In report footer

@Secoondfeetot disp

global numbervar secfeetot;

Ian

 

[kat50]

Thank you so much, but I am afraid I do know know how to enter this formula. Do I do this within my Cross tab as a calculated member?