Beast Mode is Inaccurate

BethW

I have 2 Beast Modes that are returning inaccurate results. If I place each Beast Mode in a separate column in my table, they both return their respective values of 01 or 02 for every line even though they are opposite and even though not every line meets either criterion. Any suggestions? Thanks!

CASE WHEN GL Group Code <> 170 or 175 or 190 and Current Balance >=100000 THEN '01' ELSE 'N' END

CASE WHEN GL Group Code = 170 or 175 or 190 and Current Balance <100000 and Current Balance > 0 THEN '02' ELSE 'N' END

MarkSnodgrass

I would re-write them to use IN and NOT IN like this:

CASE WHEN GL Group Code NOT IN (170, 175, 190) and Current Balance >=100000 THEN '01' ELSE 'N' END

CASE WHEN GL Group Code IN (170, 175, 190) and Current Balance <100000 and Current Balance > 0 THEN '02' ELSE 'N' END

MarkSnodgrass

I would re-write them to use IN and NOT IN like this:

CASE WHEN GL Group Code NOT IN (170, 175, 190) and Current Balance >=100000 THEN '01' ELSE 'N' END

CASE WHEN GL Group Code IN (170, 175, 190) and Current Balance <100000 and Current Balance > 0 THEN '02' ELSE 'N' END

BethW

@MarkSnodgrass that worked! Thanks so much!