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.
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.