Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a scenario where a calculation expression 'Summation' depends on the 'Duration' figure;
Raw data is something like :
Duration | Summation |
---|---|
1 | 20 |
2 | 30 |
3 | 10 |
4 | 20 |
5 | 10 |
Requirement :
Duration | Summation |
---|---|
1 | 80 |
5 | 10 |
So that 'Summation' for Duration '1' corrsponds to sum of 1 to 4 Duration , whereas 5,10,15,... should get its respective Summation Value.
I could get thru the 5,10,15,.. Summation by using Mod() function.
Would apprectiate any help on the above !
Cheers !
See attached qvw.
Here it is my example