If statement formula

[Ronal_bal]

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

[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

[Ronal_bal]

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

[binu_acs]

@Ronal_bal 

inout

output after append tool

formula tool

[Ronal_bal]

Thank you. Can you share the formula?

[Ronal_bal]

Nevermind the previous comment