Hi,
I have a data set in which I am trying to use a Multi-Row formula to get the below output.
It should assign each row a unique ID whenever the running total hits 0.
Values | Running Total | ID (OUTPUT) |
-3000 | -3000 | 1 |
-2000 | -5000 | 1 |
3000 | -2000 | 1 |
2000 | 0 | 1 |
100 | 100 | 2 |
-200 | -100 | 2 |
100 | 0 | 2 |
10 | 10 | 3 |
20 | 30 | 3 |
30 | 60 | 3 |
-40 | 20 | 3 |
-20 | 0 | 3 |
Thanks for your help!
Solved! Go to Solution.
@rajputakansha The Multi-row formula would look something like this:
IF [Row-1:Running Total]=0 THEN [Row-1:New Field]+1 ELSE [Row-1:New Field] ENDIF
Does that work for you?
It absolutely works!!
Thank you !!