2 Replies Latest reply on Oct 10, 2017 11:05 AM by Devesh Deochake

    Calculating efficiency

    Devesh Deochake

      I have a data with the following columns

      1. Name of person
      2. Type of Incident

      So i want calculate a field with the(No. of one type of incident/Total no. of incidents) for a particular person. So in short measure the efficiency. If the incident is YTD then its still not resolved otherwise it is. So basically I want to calculate for every person name the(no. of YTD for a person/total no. of incidents for a person). Now the data format is string for both column. How do I proceed with this? I tried the Count and Sum in the calculated field, not getting the desired output. Can anyone suggest something?