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
@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 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
Thank you. Can you share the formula?
Nevermind the previous comment
User | Count |
---|---|
18 | |
14 | |
13 | |
9 | |
8 |