Beast Mode is Inaccurate

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

Best Answer

  • MarkSnodgrass
    Answer ✓

    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
    

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

  • MarkSnodgrass
    Answer ✓

    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
    

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • BethW
    BethW Member

    @MarkSnodgrass that worked! Thanks so much!