Hi,
I cant work out why but True/False values are not formatting correctly, they're all being formatted as True values even if they're False values.
Attached is a screenshot of the work.
As you can see i have 3 rules, if the value is 1 or greater (true) then display a green tick, if its blank or equals 0 (false) then display a red cross. But for what ever reason its putting them all as True even if the value is False. I've also tried changing the rule so its just if value = 1 (instead of 1 or greater).
What am i doing wrong here?
Thank you.
Bookmarks