Accumulate Previous values using master calendar

Adrian1 — Sat, 16 Nov 2024 20:16:07 GMT

Hi,

I have a table with warehouse movements like this:

And I need to accumulate the Quantity of each product in a timeline dimension, and make a chart table like this:

Where for product A, the quantity at 30/06/2019 would be the sum of all previous movements.

Is it possible to do this without accumulate the values in the script?

I can obtain the accumulate for a single date using a variable with set analysis:

sum( {<DATE_MOVEMENT={">$(=date(MyDateVar))"} >} QUANTITY)

But I’m not able to obtain this values with master calendar table.

Thanks in advance!

Re: Accumulate Previous values using master calendar

sunny_talwar — Wed, 14 Aug 2019 11:41:18 GMT

Try something like this

Aggr( RangeSum(Above(Sum(QUANTITY), 0, RowNo())) , PRODUCT, (DATE_MOVEMENT, (NUMERIC)))

Adrian1 — Fri, 16 Aug 2019 06:12:55 GMT

It works! Thanks a lot!!