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.
Greg_Deckler
Community Champion
Community ChampionAnonymous 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. ❤️
- 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 )