Conditional running total

[AnanditaShankar]

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

[ShankerV]

Hi @AnanditaShankar 

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

[AnanditaShankar]

hi @ShankerV . Thanks for replying. Unfortunately this condition is not working. there are still 0 values which I see

[ShankerV]

Hi @AnanditaShankar 

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

[AnanditaShankar]

here you go @ShankerV 

[ShankerV]

Hi @AnanditaShankar 

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

[AnanditaShankar]

Still not getting the desired result