Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

If statement formula

Ronal_bal
8 - Asteroid

I'm trying to create a condition in Alteryx similar to that of below,

if(min([Arrived Run Total2])>=0,1
,if(min([#WM Scenario],RunTot_Quantity)<0,0,1)) as [Production status]


if the minimum arrived run total >=0, then 1, if the min(run tot_quantity)<0 then 0 or else 1. 


I'm not sure, how to write with minimum in the Alteryx, following code for alteryx

if min[Arrived Run Total] >=0 then 1 else
(if min[RunTot_Quantity]<0 then 0 else 1) endif
        

 

Please, someone help mw with this

 

5 REPLIES 5
binuacs
21 - Polaris

@Ronal_bal one way of dong this , first find the minimum value using the summarise tool then append the result with the input using append tool then apply your formula

 

binuacs_0-1660331470708.png

 

Ronal_bal
8 - Asteroid

@binuacs Hi, can you send me the screenshot of the input and output before select tool? I'm unable to see the wf for some reason

 

binuacs
21 - Polaris

@Ronal_bal 

 

inout

 

binuacs_0-1660333528170.png

 

output after append tool

binuacs_1-1660333550315.png

 

formula tool

 

binuacs_2-1660333592933.png

 

 

Ronal_bal
8 - Asteroid

Thank you. Can you share the formula?

Ronal_bal
8 - Asteroid

Nevermind the previous comment

Labels
Top Solution Authors