Calculate Running balance

[#1]

Hi,

I am struggling to work out how to calculate a running balance in a chart.

I want an expression that takes a figure from the total and then each row continues to calculate this as we move down the chart.

PFA a dummy target answer

Thanks

Stuart

[anbu1984 · Accepted solution]

Check this app

[ankitaag]

Hello Stuart,

Save the sum(Effect Count) in a variable

in the expressio tab write the 1st expression as effect count and check the full accumulation box below.

2nd expression as variable-column(1)

Go to the poresentation tab and check the hide column option for the 1st expression.

[awhitfield]

Hi Stuart,

see the attached, expression used is

[RunningBalance]-RangeSum(above(Sum(EffectCount),0,RowNo()))

Hope it helps!

Andy

[#5]

thanks