Forum Discussion
edavis248
Helper I
Helper INeed help with a rolling total for Percentages based off two other columns
Hi all
I have a column for percentage of contract change request to original contract. I need the % of that to be a rolling total:
Contract
| Release | amed | Contract Amount | Contract Change | % of contract |
| 1 | 1A | 100 | 50 | 5% | |
| 1 | 1B | 150 | 50 | 10% |
Basically i need the % total to cumulate for each change to the original contract.
1 Reply
PadycosmosSolution Sage
In my view, you need to have separate running totals for Contract amount and Contract Change and Change% worked out based on the running totals.
For calculating running totals, the following video might be of help
https://www.youtube.com/watch?v=y7ucCjtADsg