Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My client has provided me with a qvd that contains the mm/yy along with totals in several columns. One column is new patients for example. Each of the columns is the running total for 18 months for that metric. I have none of the raw data that was used to arrive at these totals.
I need to calculate the difference between the current row and the one prior to it for each row.
For example:
Period Total Difference
09/2019 4000 0
10/2019 4578 578
11/2019 4300 -278
I hope this makes sense and it is not a stupid question. Just not getting it today. Thanks
Try this
Table:
Load
Period,
Total,
Peek('Total',-1)-Total as Difference
from Table;