cumulative sum line chart

[MZambo89]

Hi There,
I am having some trouble making this to work.

I want to create a line chart which shows the incremental increase by month of the same amount.

This is the set analysis --> =(COUNT(DISTINCT UIN)*vTargetKPI1 )/12
vTargetKPI1 is a fixed number (2.99)

What formula should I use to achieve that? I tried rangesum(above(sum(vTargetKPI3/12)),0,rowno())) but it's not working as expected.

The result of the above set analysis is 20.43 (April 2021) so I'd like to go up to May +20.43 so 40.86 June +20.43 =61.29 and so on.

Thank you for helping! 

[sidhiq91]

@MZambo89  Could you please provide some sample data?

The expression that you have shown above should have ideally worked. 

[MZambo89]

UIN are just a number which identifies one person. ex 100256 100658 etc 
I don't use anything else on this one. It is very odd.