Switch Function - Not switching correctly..

[Anonymous]

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

[Anonymous]

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.

[Greg_Deckler · Accepted solution]

@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]

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

[Greg_Deckler]

@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
  )