12 Replies Latest reply on Jul 25, 2018 5:39 AM by Tarik Cagritekin

    Extrapolate to Full Year

    Tarik Cagritekin

      Hi All,

       

      I've a created a calculated field as follow; RUNNING_SUM(COUNT([Documents]))/MAX([FTE]);

       

       

      giving me say de following;

       

      Screenshot 2018-07-20 17.37.29.png

       

       

      Now I want do get the following;

       

      result of month 1 (which is 1,33) / 1 * 12

      result of month 2 (which is 2,33) / 2 * 12

      result of month 3 (which is 4,25) / 3 * 12

      and so on.

       

      Can someone help me on this ?

       

      Thanks in advance

       

      Regards,

       

      Terki