Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
JG
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;
JG
Thank you - perfect ! Jerry