2 Replies Latest reply on Mar 28, 2016 3:00 PM by Patrick A Van Der Hyde

    Average needed to finish the year

    Morgan DUARTE

      Hi there,

       

      I'm trying to show the average monthly business needed to achieve the target.

      Let's say the target is 120 (ie 10 per month)

      The salesmen did 5 in Jan and 5 in Feb. (Total 10, still 110 to go, ie 11 to do on the remaining 10 months)

       

      How can I display "11"

       

      However in my data set, I do not have a date field, only Year and month as string.

       

      See attached an example with my data