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

    Calculated percentage on specific date in field



      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?