topic Re: Sum - Previous Days quantity in App Development

Sum - Previous Days quantity

jerryr125 — Wed, 05 Aug 2020 13:27:05 GMT

Hi -

Is there a way to create a master measure that will do the following :

* at any given date take the previous days and sum the quantity of the previous days

Example:

08/5/2020 : Quantity 25;

08/6/2020 : Quantity 10; Master measure = current date quantity + previous dates quantities = 35

08/7/2020 : Quantity 5; Master measure = current date quantity + previous dates quantities = 40

08/8/2020 : Quantity 20; Master measure = current date quantity + previous dates quantities = 60

08/9/2020 : Quantity 2 ; ; Master measure = current date quantity + previous dates quantities = 62

Any thoughts ? Jerry

iswarya — Thu, 06 Aug 2020 04:52:53 GMT

Hi,

Kindly find the attached app. Hope it helps!

jerryr125 — Fri, 07 Aug 2020 09:38:09 GMT

Thank you very much !

Excellent example!

In the example, the master measure is the following :

aggr(Rangesum(Above(Sum(Qty),0,RowNo())),Date)

What if Qty is a master measure (say MMQTY) - how do I use the Master Measure in place of Qty ?

thoughts ?

jerryr125 — Fri, 07 Aug 2020 12:42:10 GMT

Hi - update:

I switch to variables and it working well.

OK next opportunity:

I have a total Balance on Hand (BOH) of say 10000

I would like to do the following (as an example)

Date Quantity Cumulative Quantity BOH-Cumulative Quantity

08/09/2020 20 9980

08/10/2020 100 120 9880

08/11/2020 525 645 9355

What it is displaying now is the following :

Date Quantity Cumulative Quantity BOH-Cumulative Quantity

08/09/2020 20 9355

08/10/2020 100 120 9355

08/11/2020 200 220 9355

It seems that the BOH - Cumulative Quantity is displaying the final number and not the weekly number.

Any thoughts ? Jerry

jerryr125 — Fri, 07 Aug 2020 15:25:04 GMT

Solved - thank you very much !