Convert Excel Formula to Alteryx

Question

Hi there,

Im trying to use the same formula I used on excel, on an alteryx workflow, but the language is somewhat different.

How can I translate this formula, to alteryx language?

=IF(I2=1,"G",IF(AND(H2>I2,H2>K2,H2>L2),"Y",IF(OR(K2=1,L2=1,L2>H2,K2>H2,AND(H2>I2,K2>H2),AND(H2>I2,L2>H2)),"R","check")))

H Column = % Scan Thru

I Column = In Stock Rate

K Column = OOS Rate

L Column = Unavailable Rate

ChrisTX · Answer

Alteryx formula:

IF [In Stock Rate] = 1 THEN "G"
ELSEIF [% Scan Thru] > [In Stock Rate] AND [% Scan Thru] > [OOS Rate] AND [% Scan Thru] > [Unavailable Rate] THEN "Y"
ELSEIF [OOS Rate] = 1 OR [Unavailable Rate] = 1 OR [Unavailable Rate] > [% Scan Thru] OR [OOS Rate] > [% Scan Thru] OR ([% Scan Thru] > [In Stock Rate] AND [OOS Rate] > [% Scan Thru]) OR ([% Scan Thru] > [In Stock Rate] AND [Unavailable Rate] > [% Scan Thru]) THEN "R"
ELSE "check"
ENDIF

/*

original:

=IF(I2=1,"G",IF(AND(H2>I2,H2>K2,H2>L2),"Y",IF(OR(K2=1,L2=1,L2>H2,K2>H2,AND(H2>I2,K2>H2),AND(H2>I2,L2>H2)),"R","check")))

broken down:

=IF(
I2=1,"G",

IF(
AND(H2>I2,H2>K2,H2>L2),"Y",

IF(
OR(K2=1,L2=1,L2>H2,K2>H2,
AND(H2>I2,K2>H2),
AND(H2>I2,L2>H2)),
"R","check")))

column names:

H [% Scan Thru]
I [In Stock Rate]
K [OOS Rate]
L [Unavailable Rate]

*/

Prometheus · Answer

@ancook Can you please upload some dummy data? Also, if you have a workflow even halfway built out, that would help us deliver a solution. Thanks.