Forum Discussion
Solved
SWITCH not checking 0s properly
Have an odd case here, I am double checking the values in our dashboard and the output of this formula is not reflecting the correct value for the ones with 0s which should fall under "On Time": ...
olimilo Try using == for your BLANK condition. That is an explicit comparison that should solve your problem. The = operator treats 0 and BLANK as the same thing.
olimilo Try using == for your BLANK condition. That is an explicit comparison that should solve your problem. The = operator treats 0 and BLANK as the same thing.
Thanks, I looked around and the ISBLANK() does the same thing. Good to learn about the difference between the = and == operators though.
https://community.fabric.microsoft.com/t5/Desktop/Switch-IF-condition-ignores-zero/td-p/1230199