Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Conditional statements using IF in Alteryx

AhanaR
7 - Meteor

Hi Team,

 

Could someone help in replicating this formula to Alteryx? I'm adding two criteria to calculate the Price and this is how I would write the formula in excel (replaced cell numbers with col names) I tried to write the same logic in alteryx, but it was giving me an error at greater than symbol.

 

 

IF(OR(ASP(Local)="",Unit Price In Backlog =""),0,IF(OR(Price Times<0.5,Price Times>5,Volume Exclusion="Yes"),0,(Unit Price In backlog-ASP(Local))*Backlog Quantity in Base Unit))

 

Dataset :

Unit Price In BacklogPrice Timesvolume exclusionBacklog Value in Document CurrencyASP (Local) Backlog Quantity in Base Unit
7247.691.18NO7247.691501
3692.31 NO3692.312401
17.030.86NO136.241638
54.821.04NO54.82901
9.351.18NO215.0540523
1 REPLY 1
mceleavey
17 - Castor
17 - Castor

Hi @AhanaR ,

 

I've built the following formula:

 

IF IsNull([ASP (Local) ]) or IsNull([Unit Price In Backlog]) then 0
elseif [Price Times] < 0.5 or [Price Times] > 5 or [volume exclusion] = "Yes" then 0
else ([Unit Price In Backlog] - [ASP (Local) ]) * [Backlog Quantity in Base Unit]
endif

 

This should give you what you want. Check this and let me know.

 

M.

 



Bulien

Labels
Top Solution Authors