Forum Discussion

abeirne's avatar
abeirne
Helper II
4 years ago
Solved

SWITCH function help (does not support comparing values of type true/false)

Hi I have a measure that is supposed to be determining whether certain values are met, and should sort them into either tiers 1, 2, 3, or 4. I am getting an error that says the switch function does n...
  • tackytechtom's avatar
    tackytechtom
    4 years ago

    Hi abeirne ,

     

    Could you try this? 🙂

    SA Anc/Car =
IF(
[ANC $/ Car SA] >= 43.50,
Switch( TRUE,
[ANC $/ Car SA] <= 49.49, 1,
[ANC $/ Car SA] >= 49.50 && [ANC $/ Car SA] <= 55.99 , 2,
[ANC $/ Car SA] >= 56 && [ANC $/ Car SA] <= 65.99, 3,
[ANC $/ Car SA] >= 66.00, 4 , 0)
,0)

     

    Let me know if this helps 🙂

     

    /Tom
    https://www.tackytech.blog/
    https://www.instagram.com/tackytechtom/

abeirne's avatar
abeirne
Helper II
4 years ago

Yes the 'true' works! Would you be willing to explain why this works? Thank you for your help. 🙂