2 Replies Latest reply: Dec 11, 2013 11:20 AM by Gerrit Zanen RSS

    Conditional Sum

    Naheem Ali

      Hi

      I am trying to create Cost Centre Budget Report. The data im using is from a database in raw form so having to manipulate it to create the CC report.

       

      Period     Budget     YTD          Spend          YTD Spend

      1             1000         1000          800                800

      2             1000         2000          800               1600

      3             1000         3000          800               2400

      4             1000        4000          800               3200

      5             1000         5000          800              4000

      6             1000         6000          800               4800

       

      And So on....

       

      I have the budget & Spend figures but need to create YTD Budget & YTD Spend totals. 

       

      Can anyone help.

       

      Regards