formula alternative

[vern]

is there an alternative way of processing the following calculation in Alteryx?

Output Column

MISC_

if [PAY_SUM_GRP] != "ADJ" and
[PAY_SUM_GRP] != "ASC" and
[PAY_SUM_GRP] != "BIN" and
[PAY_SUM_GRP] != "BNT" and
[PAY_SUM_GRP] != "DIF" and
[PAY_SUM_GRP] != "EXP" and
[PAY_SUM_GRP] != "GC" and
[PAY_SUM_GRP] != "GTL" and
[PAY_SUM_GRP] != "HBD" and
[PAY_SUM_GRP] != "HBN" and
[PAY_SUM_GRP] != "HHO" and
[PAY_SUM_GRP] != "HO1" and
[PAY_SUM_GRP] != "HPH" and
[PAY_SUM_GRP] != "HRG" and
[PAY_SUM_GRP] != "HVA" and
[PAY_SUM_GRP] != "LMP" and
[PAY_SUM_GRP] != "LTD" and
[PAY_SUM_GRP] != "RTN" and
[PAY_SUM_GRP] != "SBN" and
[PAY_SUM_GRP] != "SDI" and
[PAY_SUM_GRP] != "SHO" and
[PAY_SUM_GRP] != "SIL" and
[PAY_SUM_GRP] != "SMR" and
[PAY_SUM_GRP] != "SOB" and
[PAY_SUM_GRP] != "SPH" and
[PAY_SUM_GRP] != "SR" and
[PAY_SUM_GRP] != "SRG" and
[PAY_SUM_GRP] != "SSC" and
[PAY_SUM_GRP] != "SVA"
THEN [WAGE_AMOUNT]
ELSE 0
ENDIF

Data type: FixedDecimal     Precision: 15     Scale: 2

[Kenda]

Hi @vern 

You could add all of those values to a Text Input tool then just a join tool on your data set. For any values that join (where the value would match), add a formula tool from the J output that sets the field to 0. For the records that don't join, use a formula tool to set the field to the WAGE_AMOUNT. 

Hope this helps!