1 Reply Latest reply on Jun 17, 2016 8:23 AM by Tom W

    Estimated Actual for Full Year?

    doRs Aparente

      Need syntax formula to compute 'estimated actual' for full year.

       

      Sample data:

      Actual Monthly sales

      A_Month 1 = 10M

      A_Month 2 = 6 M

      A_Month 3 = 4M

      A_Month 4 = 7M

      A_Month 5 = 5M

       

      Monthly Target:

      T_Month 1=  9M

      T_Month 2 = 5M

      T_Month 3 = 3M

      T_Month 4 =  6M

      T_Month 5 = 5M

      T_Month 4=  9M

      T_Month 5 = 5M

      T_Month 6 = 3M

      T_Month 7 =  6M

      T_Month 8 = 5M

      T_Month 9=  9M

      T_Month 10 = 5M

      T_Month 11 = 3M

      T_Month 12 =  6M

       

      Estimated Actual for full year as  of Month 5

           = (A_Month 1+ A_Month 2 + A_Month 3 + A_Month 4 + A_Month 5  +

             T_Month 6 + T_Month 7 +  T_Month 8 +  T_Month 9 +  T_Month 10 +  T_Month 11 +  T_Month 12)

       

       

      Thanks heaps in advanced.