Show Posts
1
Here is my sample query:
SELECT TO_CHAR(c.END_DATE,'Month YYYY') years,
SUM (b.plan_total_lcl) plan_total,
SUM (b.actual_total_LCL) actual_total
FROM KCST_BUDGET_PERIOD_SUM a,
KCST_CURRENCY_LINES b,
KNTA_PERIODS c
WHERE a.BUDGET_ID = (SELECT z.PRJ_BUDGET_ID FROM KCRT_FG_PFM_PROJECT z WHERE z.REQUEST_ID = 43985)
AND a.currency_line_id = b.currency_line_id
AND c.period_id = a.period_id
GROUP BY TO_CHAR(c.END_DATE,'Month YYYY')
ORDER BY 1
Results:
I need the SUM of PLAN_TOTAL form June 2009 to Septermber 2009
D
SELECT TO_CHAR(c.END_DATE,'Month YYYY') years,
SUM (b.plan_total_lcl) plan_total,
SUM (b.actual_total_LCL) actual_total
FROM KCST_BUDGET_PERIOD_SUM a,
KCST_CURRENCY_LINES b,
KNTA_PERIODS c
WHERE a.BUDGET_ID = (SELECT z.PRJ_BUDGET_ID FROM KCRT_FG_PFM_PROJECT z WHERE z.REQUEST_ID = 43985)
AND a.currency_line_id = b.currency_line_id
AND c.period_id = a.period_id
GROUP BY TO_CHAR(c.END_DATE,'Month YYYY')
ORDER BY 1
Results:
| YEARS | PLAN_TOTAL | ACTUAL_TOTAL |
| October 2009 | 160,562.00 | 181,860.00 |
| August 2009 | 160,562.00 | 222,495.00 |
| November 2009 | 160,562.00 | 150,990.00 |
| July 2009 | 160,562.00 | 129,990.00 |
| December 2009 | 160,562.00 | 0.00 |
| September 2009 | 160,562.00 | 198,870.00 |
| June 2009 | 963,374.00 | 952,539.00 |
I need the SUM of PLAN_TOTAL form June 2009 to Septermber 2009
D
