Forum Discussion
Switch Function - Not switching correctly..
May someone let me know what I am doing wrong. The end result is suppse to be 2.
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.
Thank you - I did a Power Querey and rounded that column exactly to the two decimal place. ❤️
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
)