Continuous reduction between rows with criteria

Help,

I want to determine the column values ​​-/+

This value is taken from the actual column value - the actual value in the previous row

where in determining the -/+ column values ​​are also determined using the same ID criteria

 

Report Periode-/+PlanActual
19/07/20241%100%90%
12/07/20244%100%89%
05/07/20246%100%85%
28/06/20242%100%79%
21/06/20242%100%77%
14/06/20245%100%75%
07/06/202410%100%70%
31/05/2024 100%60%
Solved Solved
0 4 146
1 ACCEPTED SOLUTION

Since you have rows of different IDs intermixed appearing at random you need to use a few constraints to get to the right row.

Report period less than thisrow, ID equals thisrow. Use ORDERBY and INDE X.

View solution in original post

4 REPLIES 4
Top Labels in this Space