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 |
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.
User | Count |
---|---|
109 | |
92 | |
78 | |
54 | |
40 |