All,
Ref | Amt |
210-10 | 5000 |
EST | |
210-05 | -200 |
PY-M1 | 200 |
I am trying to calc the missing number in the Amt column that corresponds to the EST in the Ref column. The calc would be EST = (210-05/PY-M1) * 210-10 so (-200/200)*5000
So in the configuration pane of the multi row formula tool. I set Num Rows to 2. then enter IF [Ref] = "est" THEN [AMT] = ([Row-2:AMT]/[Row-1:AMT])*[Row+1:AMT] ELSE [AMT] ENDIF
The output shows zero instead of -5000.
Any help would be greatly appreciated.
Solved! Go to Solution.
I'm going to make the assumption that the rows are always in the correct order. It looks like you got your +/- rows backwards. If you still get a 0, then make sure you are using literal match of "EST".
Thanks! Your formula worked!