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.

Convert Excel Formula to Alteryx

ancook
6 - Meteoroid

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

2 REPLIES 2
Prometheus
12 - Quasar

@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.

ChrisTX
16 - Nebula
16 - Nebula

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]

*/

Labels
Top Solution Authors