Cumulative issue

[RobMazaheri]

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 · Accepted solution]

Hi, @RobMazaheri 

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

RangeSum(

               Above(

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

[RobMazaheri]

that's worked a treat thank you so much