Apr 29 2022 03:21 AM
Hi experts,
I would like to calculate cumulative number from range of numbers, attached file for your review.
Please help me to create calculated field for the same.
Team | HC | Production | Running total % | HC*Running total % |
Test | 35 | 428 | 69% | 24.16 |
30 | 57 | 9% | 2.76 | |
19.5 | 54 | 9% | 1.70 | |
29 | 30 | 5% | 1.40 | |
28 | 30 | 5% | 1.35 | |
0 | 21 | 3% | 0.00 | |
Test Total | 620 | 0% | 31.38 | |
Test1 | 15 | 213 | 78% | 11.66 |
5 | 61 | 22% | 1.11 | |
Test1 Total | 274 | 0% | 12.77 |