=IF(AND(ABS(AD6)>0,Y6=0,AZ6<>"EXP_TX",AZ6<>"SELUNWD_TX"),"FAIL","PASS")
Is putting this in Alteryx possible? I'm running into problems and not sure where to start.
Solved! Go to Solution.
The Alteryx syntax with Excel arguments is:
IF <logical_test> THEN <value_if_true>
ELSE <value_if_false> ENDIF
and since you want both conditions, use "(<logical_test1> and <logical_test2>)"
Without testing it, it should be:
IF (ABS(AD6)>0,Y6=0,AZ6<>"EXP_TX" AND AZ6<>"SELUNWD_TX") THEN "FAIL"
ELSE "PASS" ENDIF
Let me know if that works.
I tried that and it still says Malformed if Statement. It looks like it's not registering anything after the first condition. See screenshot below. Thanks
Assuming that [BaseRealizedGL] is a Numeric data type.....
is there ever a time that the absolute value of a number is less than 0?
IF ABS([BaseRealizedGL]) > 0 && [BaseProceeds] = 0 && [close tx type] NOT IN("EXP_TX","SELUNWD_TX") THEN "FAIL" ELSE "PASS" ENDIF
Cheers,
Mark
Oops, I missed another <logical_test> that needed an "AND"/"&&". Good thing @MarqueeCrew was here to save the day.
Haha good point. Appreciate the help
I can't keep up with you. Fortunately, you left me a little opening to help someone. Thanks for all of the effort in helping the community. I see your effort and give you public kudos for it.
Cheers,
Mark