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, then 1, if the min(run tot_quantity) =0 then 1 else (if min[RunTot_Quantity]<0 then 0 else 1) endif Please, someone help mw with this

If statement formula

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

Data Investigation

Accepted answers

All comments

binu_acs

@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