topic Cumulative issue in Insight Advisor

Cumulative issue

RobMazaheri — Wed, 20 Sep 2023 10:45:05 GMT

Hi using this formula to calculate cumulative but its not working - works for a few lines then seems not to work

RangeSum(Above(SUM(SUBMITTED_THP),0,3))

I know its not possible to do a cumulative view in pivot as if there is a zero it cant see past that value

MatheusC — Wed, 20 Sep 2023 11:58:55 GMT

See with the RowNo() function that returns the number of rows

RangeSum(

Above(

SUM(SUBMITTED_THP),0,RowNo()))

RobMazaheri — Thu, 21 Sep 2023 13:32:13 GMT

that's worked a treat thank you so much