5 Replies Latest reply: Sep 6, 2018 4:42 PM by William Fu RSS

    Calculating Percentage of Achieved SLA

    Luke Pain

      Afternoon all,

       

      I'm struggling to put together a formula that would allow me to calculate what percentage of our cases hit our SLA.

       

      We currently have a field 'Age' measured in days against each line (Case), our SLA is 3 days, so would need to calculate first how many cases we have (count) then how many are aged over 3 days (count if) and the calculate the percentage of those over, allowing us to see our SLA percentage.

       

      Any ideas?

       

      Thanks,