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

    Counting Multiple Values

    Paul Smith

      Hi

       

      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

       

      Thanks

       

      Paul