Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
Been working for days and can't seem to find the right way to do a running balance.
This is the output I'm trying to achieve:
Total
Balance
10852
1
10851
10850
2
10848
3
10845
5
10840
10835
10
10825
10815
10805
10795
20
10775
10755
25
10730
10705
50
10655
60
10595
10590
8
10582
I need to add an expression balance as shown above to the attached chart.
I tried RangeSum(Above(Total),0,RowNo()) but it's adding, not subtracting.
Thanks in advance.
-R