Rolling value but not

[#1]

Hi,

I am looking to do something similar to the accumulation function. But instead of it calculating each row in turn and then adding it on, I would like it add up the total of each column and then calculate the ratio between amount and the paid.

What Full accumulation gives me

Month	Amount	Paid	Ratio
Jan	10	100	0.1
Feb	0	100	0.1
Mar	100	200	0.6

Expected result

Month	Amount	Paid	Ratio
Jan	10	100	0.1
Feb	0	100	0.05
Mar	100	200	0.275

Thanks in advance

[Nicole-Smith]

See attached example.

In case you only have personal edition:

Dimension: Month

Expression 1: sum(Amount)

Expression 2: sum(Paid)

Expression 3: RangeSum(above(Amount, 0, FieldValueCount('Month')))/RangeSum(above(Paid, 0, FieldValueCount('Month')))