Row Cumulative calculation in a Crosstab 1

[jonav]

Hi,

I have a Crosstab with Fiscal year as column , Bex structure as row and Amount as Summary.

I'm trying to do a cumulative calculation for specific rows in a crosstab.

Pls guide.

Thanks
JN

 

[lbass]

I don't know what you mean.

-LB

 

[jonav]

other than cumulative values it is still showing 0's. this is no a priority anyway.

Your solution worked like magic.. that's all i Meant.

Thanks,
JN

 

[lbass]

Try changing it to:

if round(currentfieldvalue,0)=0 then

-LB

 

[jonav]

OK ,, will do it.

Thanks,
JN