Conditional statements using IF in Alteryx

[AhanaR]

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 Backlog	Price Times	volume exclusion	Backlog Value in Document Currency	ASP (Local)	Backlog Quantity in Base Unit
7247.69	1.18	NO	7247.69	150	1
3692.31		NO	3692.31	240	1
17.03	0.86	NO	136.24	163	8
54.82	1.04	NO	54.82	90	1
9.35	1.18	NO	215.05	405	23

[mceleavey]

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.