topic Re: Accumulative Sum reseting in a new year in App Development

Accumulative Sum reseting in a new year

gitguto — Sat, 07 Aug 2021 23:40:55 GMT

Hello community,

I need to create a field with the accumulated (month by month) sum of the measure sum(ESTOQUE).

I tried using the RangeSum(Above([MEASURE],0,RowNo(TOTAL))) method, but something is not working, as you can see in the image below, the accumulation sum resets when it reaches January of a new year. I thought this should be fixed with the argument TOTAL inside the RowNo function, but it does not work somehow.

=RangeSum(Above(Sum({$<[CALDAY.autoCalendar.YearMonth]>} ESTOQUE),0,RowNo(TOTAL)))

Does anyone has a clue of what is wrong?

Re: Accumulative Sum reseting in a new year

MayilVahanan — Sun, 08 Aug 2021 01:01:42 GMT

Try like below

=RangeSum(Above(Total Sum({$<[CALDAY.autoCalendar.YearMonth]>} ESTOQUE),0,RowNo(TOTAL)))

Re: Accumulative Sum reseting in a new year

anthonyj — Mon, 09 Aug 2021 04:01:24 GMT

Hi,

It's an interesting question. I tried this with a date using the autocalendar Year in one column and the Month in the other just as your example and it did the exact same thing. But when I only used the autocalendar.YearMonth column it worked as expected accumulating through all the rows.

Maybe someone can explain why this would be the case.

Regards

Anthony

Re: Accumulative Sum reseting in a new year

gitguto — Mon, 09 Aug 2021 21:13:34 GMT

Thank you Mayil!

It worked perfectly.