7 Replies Latest reply: Jan 25, 2014 9:06 AM by Paul Smith RSS

    Counting Multiple Values

    Paul Smith



      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.


      =Count( if(Status ='Open','Project',([Problem ID])) )


      Any Help would be greatly appreciated