Hi,
I'm working on a workflow where I would like to calculate the total budget. This budget, however, cannoot exceed the limit. So when the limit is reached the budgets of the other days will not be included.
See below an example:
Project ID | Budget | Date | Limit amount |
123 | 100 | 2022-10-24 | 400 |
123 | 100 | 2022-10-25 | 400 |
123 | 250 | 2022-10-25 | 400 |
123 | 100 | 2022-10-26 | 400 |
456 | 250 | 2022-11-04 | 325 |
456 | 50 | 2022-11-04 | 325 |
456 | 100 | 2022-11-05 | 325 |
456 | 150 | 2022-11-08 | 325 |
So, for Project 123 the limit is 400. That means that only the sum of the first two rows is below budget, which means the total budget is 200
For Project 456 the limit is 325. That means that the sum of the first three rows is below budget, which means the total budget is 300
The output I would like to receive:
Project ID | SUM_Budget |
123 | 200 |
456 | 300 |
In the real file, this must be done for many projects. Is there a way how I can calculate this?
Thanks in advance!
Solved! Go to Solution.
You can use the multi-row formula tool to get the desired output.
Many thanks
Shanker V