Forum Discussion
Issue with quantity difference between two dates when sorting by date descending
I missed the wrong PREVIOUSDAY reference
Hello Ibdendlin,
You'll find the report right here.
The expected result would be as below in term of calculation: the delta D-1 is what is the difference between D0 and D-1 data (based on the snapshot date in column), but the sorting of the column values should be from the most recent to the oldest => first column displays 2024-12-02 data, second column 2024-12-01, etc.
see attached.
Hello Ibdendlin,
Unfortunately, the formula remains broken with the sorting by date descending.
We can see that the Qty Δ D-1 isn't showing the difference between D0 quantity and D-1 quantity.
As displayed in my previous screenshot, for category A, the delta should be -400 on 12/02, -200 on 12/01, etc. The values should be like in my message 7 (or the very first screenshot on the message 1).
I missed the wrong PREVIOUSDAY reference
And it's working 🙂
I think I get the logic, thanks a lot for your help on this topic lbendlin!