I'm trying to write an expression which i can't seem to get to work, Its for a text Object, Please could someone advise what im doing wrong? Problem ID is a column of call reference numbers, and i just want to count all the calls with Open and Project Status? however when use the below it counts everything including calls with a status of Closed.
Thanks for your help, I have used =count( if(Status = 'Open' or Status='Project', [Problem ID]))
However when used in a pie chart with the same expression, it seems to be adding Others with zero? even though "Others" is not in any of the tables, Any ideas how to exclude or remove this info so it just shows Project and Open?