Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Switch Function - Not switching correctly..

May someone let me know what I am doing wrong. The end result is suppse to be 2. 

 

 

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    Anonymous I'm wondering if the value is not exactly 0.89 but that it is just being displayed that way due to how many decimal places you have chosen to display.

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    2 years ago

    Anonymous I'm wondering if the value is not exactly 0.89 but that it is just being displayed that way due to how many decimal places you have chosen to display.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Thank you - I did a Power Querey and rounded that column exactly to the two decimal place. ❤️  

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        2 years ago

        Anonymous So as an experiment, what happens if you change your statement to this:

        Column = 
  SWITCH( TRUE(),
    [EE Compa-Ratio] > .88999999999999999999 && [EE Compa-Ratio] < .8901, 2,
    10
  )
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

     

    I think your data in [EE Compa-Ratio] column should in range  of >=0.885 and <0.895.

    Please try code as below to create a calculated column.

    Column =
SWITCH ( TRUE (), [EE Compa-Ratio] >= 0.885 && [EE Compa-Ratio] < 0.895, 2, 10 )

     

    Best Regards,
    Rico Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.