How to get Month & Year Budget

Hi All,

I'm working on a report that shows the Monthly & Yearly Budget against the actual spend. I've managed to get the Monthly & Yearly Actual amounts working but I'm having trouble getting the correct amounts for the Monthly & Yearly Budgets.

This is the query I have so far...

SELECT        period_name PERIOD,

            gbv.budget_name,

            pap.full_name AS Manager,

            segment1 DIV,

            segment2 COST_CENTRE,

            segment3 EXPENSE_CODE,

            gl_flexfields_pkg.

             get_description_sql (chart_of_accounts_id,

                       3, -- Position of segment in Accounting Flexfield (3 = Account Code)

                       segment3)

              AS Description,

            SUM (DECODE (actual_flag, 'A', NVL (period_net_dr, 0)))

            - SUM (