Forum Discussion
Getting incremental values from cumulative figures
Hi, I have a data set that records expected final fee and percentage complete for a number of projects, the table records one line per project per month. Both the final fee and the percentage ca...
| ProjectID | Month Closed | Fee | Percentage Complete | Cumulative Fee |
| 553668 | 01/09/2018 | 0 | 100 | 0 |
| 553668 | 01/10/2018 | 0 | 100 | 0 |
| 553668 | 01/11/2018 | 0 | 100 | 0 |
| 553668 | 01/12/2018 | 0 | 100 | 0 |
| 553668 | 01/01/2019 | 182.5 | 100 | 182.5 |
| 553668 | 01/02/2019 | 182.5 | 100 | 182.5 |
| 553668 | 01/03/2019 | 182.5 | 100 | 182.5 |
| 553668 | 01/04/2019 | 182.5 | 100 | 182.5 |
| 553681 | 01/01/2019 | 21150 | 0 | 0 |
| 553681 | 01/02/2019 | 21150 | 0 | 0 |
| 553681 | 01/03/2019 | 21150 | 0 | 0 |
| 553681 | 01/04/2019 | 21150 | 0 | 0 |
| 553681 | 01/05/2019 | 21150 | 0 | 0 |
| 553681 | 01/06/2019 | 21150 | 0 | 0 |
| 553681 | 01/07/2019 | 21150 | 0 | 0 |
| 553681 | 01/08/2019 | 21150 | 0 | 0 |
| 553681 | 01/09/2019 | 21150 | 0 | 0 |
| 553681 | 01/10/2019 | 21150 | 46.42 | 9817.83 |
| 553681 | 01/11/2019 | 24900 | 39.43 | 9818.07 |
| 553681 | 01/01/2020 | 24900 | 39.43 | 9818.07 |
| 553681 | 01/02/2020 | 24900 | 39.43 | 9818.07 |
| 553681 | 01/03/2020 | 24900 | 100 | 24900 |
| 553681 | 01/04/2020 | 24900 | 100 | 24900 |
| 553683 | 01/11/2018 | 0 | 100 | 0 |
| 553683 | 01/12/2018 | 0 | 100 | 0 |
| 553683 | 01/01/2019 | 162000 | 0 | 0 |
| 553683 | 01/02/2019 | 162000 | 0 | 0 |
| 553683 | 01/03/2019 | 162000 | 0 | 0 |
| 553683 | 01/04/2019 | 162000 | 0 | 0 |
| 553683 | 01/05/2019 | 135480 | 0 | 0 |
| 553683 | 01/06/2019 | 135480 | 0 | 0 |
| 553683 | 01/07/2019 | 135480 | 0 | 0 |
| 553683 | 01/08/2019 | 135000 | 0.11 | 148.5 |
| 553683 | 01/09/2019 | 135000 | 0.11 | 148.5 |
| 553683 | 01/10/2019 | 135000 | 0.11 | 148.5 |
| 553683 | 01/11/2019 | 135000 | 0.11 | 148.5 |
| 553683 | 01/01/2020 | 135000 | 0.11 | 148.5 |
| 553683 | 01/02/2020 | 135000 | 0.11 | 148.5 |
| 553683 | 01/03/2020 | 135000 | 0.11 | 148.5 |
| 553683 | 01/04/2020 | 135000 | 0.11 | 148.5 |
| 553683 | 01/05/2020 | 135000 | 48.27 | 65164.5 |
| 553683 | 01/06/2020 | 135000 | 48.27 | 65164.5 |
| 553683 | 01/07/2020 | 135000 | 52.99 | 71536.5 |
| 553683 | 01/08/2020 | 135000 | 52.99 | 71536.5 |
| 553683 | 01/09/2020 | 135000 | 52.99 | 71536.5 |
| 553683 | 01/10/2020 | 135000 | 52.99 | 71536.5 |
| 553683 | 01/11/2020 | 135000 | 52.99 | 71536.5 |
| 553683 | 01/12/2020 | 135000 | 52.99 | 71536.5 |
| 553683 | 01/01/2021 | 65911.5 | 100 | 65911.5 |