5 Replies Latest reply on Oct 15, 2018 10:46 AM by Mahfooj Khan

    Calculated field requiring percent target achieved sorted by months

    Sarah Hussain

      Hello,

       

      My workbook is attached to this post. Jim Dehner , helped me with the original calculation "Target achieved ". I used the formula

      SUM(IF([Exit Message]='complete')THEN 1 ELSE 0 END)/1880*100. The column Exit message has no null values.

       

      The end user wants to see a monthly target achieved for the surveys being carried out only for completed surveys not for incomplete ones.

      How will the formula be modified to insert a monthly percentage for target achieved?

       

      Sarah.