6 Replies Latest reply on May 23, 2012 10:32 AM by johnslater

    Mixing Budget and Forecast Data

      Hi All

       

      I have what I hope is a very simple problem.  I have a month by month table with two lines of data an actual line and a budget line (workbook attached).  I want to create a third line which shows a mix of the two based on the month I am in.  So with the following table (and being in May):

       

       

      My third calculated line would read:

       

      Calculation     150     250     300    400     500     600     700     800     900     1,000     1,100     1,200     7,900

       

      Thanks

       

      John