Hi. I want to calculate running total based on condition that if Sum_Inv (BBL)= 0 , it should populate the number as is and if it's not then calculate the running total(RunTot_Sum_Inv (BBL). Attaching sample file. Expected output is in Column M
Please make use of the below steps to get the expected output.
1. Use MultiRow Formula Tool
Select Create New Field
Expression:
IF [RunTot_Sum_Inv (BBL)] = 0
THEN [Row-1:RunTot_Sum_Inv (BBL)]
ELSE [RunTot_Sum_Inv (BBL)]
ENDIF
Many thanks
Shanker V
hi @ShankerV . Thanks for replying. Unfortunately this condition is not working. there are still 0 values which I see
Can you please post the screenshot of Multirow tool configuration applied, so will be easy to investigate.
As I tired and the condition was working fine.
Many thanks
Shanker V
here you go @ShankerV
Please try the below formula. Have tweaked to get your expected output.
IF [RunTot_Sum_Inv (BBL)] != 0
THEN [RunTot_Sum_Inv (BBL)]
ELSE [Row-1:Modified Running total]
ENDIF
Many thanks
Shanker V