ytd calculation
From: raja <dextersunil_at_gmail.com>
Date: Wed, 3 Feb 2010 03:19:14 -0800 (PST)
Message-ID: <ce73faa3-97fd-4b4d-9ac3-feaa7ad1fa89_at_a17g2000pre.googlegroups.com>
Hi,
Date: Wed, 3 Feb 2010 03:19:14 -0800 (PST)
Message-ID: <ce73faa3-97fd-4b4d-9ac3-feaa7ad1fa89_at_a17g2000pre.googlegroups.com>
Hi,
If, I want to calculate ytd ( year to date calculation ), then i have to sum up monthly then sum up for yearly. Eg : I have to calculate YTD as follows :
GL Curr Day Amount Month YTD
5805 45454 1-Jan 5.23 5.23 5.23 5805 45454 2-Jan -4.52 0.71 5.94 5805 45454 3-Jan 25.3 26.01 31.95 5805 45454 4-Jan 10.53 36.54 68.49 5805 45454 5-Jan -1.88 34.66 103.15
how can i do this ytd using rollup or group by clauses (i.e., i have to sum up for every row) ?
Thanks.
With Regards,
Raja.
Received on Wed Feb 03 2010 - 05:19:14 CST