Skip to Content
0

Amount in Total

Mar 07 at 02:54 PM

29

avatar image

How do l get rollup total, l have following data.

May YTD Amount - 1500
June YTD Amount - 1600
July YTD Amount - 1750.

What I need is
June Actual Amount - 3100 -- (1600 plus1500)

July Actual Amount - 4700 -----(3100 plus 1600)

Aug Actual Amount - 6450 ----(4800 plus 1750).

I used relativevalue but does not rollup the amount continuously.

Thanks

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
AMIT KUMAR
Mar 07 at 03:03 PM
0

use runningsum() function.

Share
10 |10000 characters needed characters left characters exceeded