6 Replies Latest reply: Feb 7, 2014 9:11 AM by Jonathan Ditchfield RSS

    Calculated percentage on specific date in field

      Hi,

       

      I have the below expression which calculates the percentage of calls where the withinfix field is No by doing a count of the field callref.

       

      =num(count({$<[withinfix]={No}>} withinfix)  / count(callref), '##.00%')

       

      However I want to filter it futher by picking up the above only if the location field = 'CLO'.  How would I do this?

       

      Regards,

       

      Jon