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 | -/+ | Plan | Actual |
19/07/2024 | 1% | 100% | 90% |
12/07/2024 | 4% | 100% | 89% |
05/07/2024 | 6% | 100% | 85% |
28/06/2024 | 2% | 100% | 79% |
21/06/2024 | 2% | 100% | 77% |
14/06/2024 | 5% | 100% | 75% |
07/06/2024 | 10% | 100% | 70% |
31/05/2024 | 100% | 60% |
Solved! Go to 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.
User | Count |
---|---|
28 | |
14 | |
3 | |
3 | |
3 |