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.
  1. is this correct for month summation alone ?
  2. 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

Original text of this message