We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Conditional running total

AnanditaShankar
8 - Asteroid

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

6 REPLIES 6
ShankerV
17 - Castor

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
8 - Asteroid

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

 

 

ShankerV
17 - Castor

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
8 - Asteroid

here you go @ShankerV 

ShankerV
17 - Castor

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
8 - Asteroid

Still not getting the desired result

Labels
Top Solution Authors