Trying to make a column 0 based off of another column that is already 0.

Question

Hello,

I am new to Alteryx and am struggling with figuring this out. Essentially, I have two columns a [CustomerSpending] column and a [PurchaseMade] column. If one of these columns is 0 then they both should be 0. Unfortunately that is not always the case which is why I am trying to clean this up a little. How can I make each column 0?

I thought it would be something as simple as this:

IF [CustomerSpending] > 0
then [PurchaseMade] = 0
ELSE [CustomerSpending]
ENDIF

Thank you!

lmorrell · Accepted Answer

Hi @KonaCantTalk

Workflow is attached

Your logic is spot on - however as each formula applies to a single column, we aren't able to overwrite multiple cell values with a single formula. However, by breaking these two formulas up - we can apply the rules to two temp columns with two formulas as below, deselect the originals, and then carry the temp columns forward for further processing.

CustomerSpending_Temp

if [CustomerSpending] = 0 OR [PurchaseMade] = 0 then 0 
else [CustomerSpending]
endif

PurchaseMade_Temp

if [CustomerSpending] = 0 OR [PurchaseMade] = 0 then 0 
else [PurchaseMade]
endif

Hope this helps!