Expression for Top Level

Anonymous — Tue, 19 Aug 2014 11:42:42 GMT

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

topic Expression for Top Level in QlikView