Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Please help what is wrong in the below rangesum expression. I am unable to display cumulative totals .
rangesum(above((Count({<[MASTER_CALENDER.Year]={'$(=$(VSelectYr))'},
[MASTER_CALENDER.Date]={"<$(=$(VSelectDate))"},[CASE.COUNT]={'1'}
CASE.CASE_ID)),0,rowno()))
Do you see anything with your expression? May be try this
RangeSum(Above(Count({<[MASTER_CALENDER.Year] = {'$(=$(VSelectYr))'}, [MASTER_CALENDER.Date] = {"<$(=$(VSelectDate))"}, [CASE.COUNT] = {'1'}>} CASE.CASE_ID), 0, RowNo()))