Expression for Top Level

[Anonymous]

Hello Dears,

Can some body help me why same expression working fine at detail level and not working fine at Top level(Giving garbage values)

I have used following expressions:

Accumulated CL="Total_CL- rangesum(above(total sum({<LEAVECODE={'CL'}>}leavedays), 1, rowno(Total)))"

CL Accrued="if(LEAVECODE='CL', sum(leavedays),'0')"

Closing CL Balance="Total_CL- rangesum(above(total sum({<LEAVECODE={'CL'}>}leavedays), 0, rowno(Total)))"

Here Total_CL is a static value and rest are dynamic values.

I have attached the output as well.

Please update if their is any error in expressions which are mentioned above.

Regards,

Balraj