Re: ytd calculation
From: raja <dextersunil_at_gmail.com>
Date: Thu, 4 Feb 2010 03:12:32 -0800 (PST)
Message-ID: <0a58944a-967d-46e6-bb74-57044bda60ca_at_u19g2000prh.googlegroups.com>
I have tried an example.
SUM(A.FUNC_AMNT) MONTH
OVER
(
ORDER BY
ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW ) AS "YTD"
FROM
MASTER B,
TRANSACTION A
WHERE ( A.ACCN_PERIOD_COD = B.ACCN_PERIOD_COD ); Please help... Received on Thu Feb 04 2010 - 05:12:32 CST
Date: Thu, 4 Feb 2010 03:12:32 -0800 (PST)
Message-ID: <0a58944a-967d-46e6-bb74-57044bda60ca_at_u19g2000prh.googlegroups.com>
I have tried an example.
- is this correct for month summation alone ?
- should i again do the same procedure to get for year summation too ? i.e., take the below query data ( month summation ) as input and again form the same query for year summation ?
SELECT
A.CURR, A.DATA_TYPE_COD, A.GL_POST_ACCN, A.PRDMKT_COD, A.SCENARIO_COD, A.ACCN_PERIOD_COD, A.TRANS_DES, A.CURRENCY_TRAN_COD, A.REP_ENT_COD, A.COST_CENTER, B.ACCN_PERIOD_COD, B.ACCN_YEAR, B.CURR_ACCN_START_DT, A.FUNC_AMNT,
SUM(A.FUNC_AMNT) MONTH
OVER
(
ORDER BY
A.CURR, A.DATA_TYPE_COD, A.GL_POST_ACCN, A.PRDMKT_COD, A.SCENARIO_COD, A.ACCN_PERIOD_COD, A.TRANS_DES, A.CURRENCY_TRAN_COD, A.REP_ENT_COD, A.COST_CENTER, B.ACCN_PERIOD_COD, B.ACCN_YEAR, B.CURR_ACCN_START_DT, A.FUNC_AMNT
ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW ) AS "YTD"
FROM
MASTER B,
TRANSACTION A
WHERE ( A.ACCN_PERIOD_COD = B.ACCN_PERIOD_COD ); Please help... Received on Thu Feb 04 2010 - 05:12:32 CST