topic Data Load - Calculate the difference between cumulative values in App Development

Data Load - Calculate the difference between cumulative values

jerryr125 — Tue, 04 May 2021 12:58:19 GMT

Hi -

I am not entirely sure if the following can be accomplished.

On the data load, I would like to calculate the difference between values instead of the cumulative value.

That is, by date and location, determine the difference in quantity between the two dates.

Example:

Therefore, the OUTPUT is the results I am attempting to achieve for the data load.

Any thoughts ?

Thanks - Jerry

Re: Data Load - Calculate the difference between cumulative values

JuanGerardo — Tue, 04 May 2021 18:55:34 GMT

Hi @jerryr125 , you can use the Previous() function to calculate this difference:

Output:

Load

Date,

Location,

If(Location = Previous(Location), [Quantity Sold Cummulative] - Previous([Quantity Sold Cummulative]), [Quantity Sold Cummulative]) AS [Quantity Sold]

Resident Input // Or from your data connection

Order by Location, Date;

Re: Data Load - Calculate the difference between cumulative values

jerryr125 — Tue, 04 May 2021 23:00:01 GMT

Thank you - perfect ! Jerry