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