| need help [message #430483] |
Tue, 10 November 2009 10:57  |
aarti81
Messages: 235
Registered: December 2007
Location: USA
|
Senior Member |
|
|
Hi All,
I need help with the following situation:
I have a report as follows
FY DISTRICT TONS USED % DIFFERENCE BETWEEN FY's
2008 DISTRICT A 2000
DISTRICT B 5050
DISTRICT C 1800
DISTRICT D 4000
2009 DISTRICT A 2200
DISTRICT B 6000
DISTRICT C 3200
DISTRICT D 1200
In the 3 column(% difference between the ton's used between the FY's) i want a value as follows for example:
FOr district A, FY-2009 it should show the value as ((2200-2000)/2200)*100=9%, is there any function in disco plus that does this?
Please any help and advice is greatly appreciated.
Thanks
|
|
|
|
| Re: need help [message #434836 is a reply to message #430483] |
Fri, 11 December 2009 03:21  |
dhinendra
Messages: 58
Registered: September 2009
Location: Gurgaon,India
|
Member |
|
|
hi i think you have to use formula columns in this condition,just make 12 formula column for every month and then in those formula column use the code-
select amount into n1 from tablename
where
month='monthname'
and fy ='2009'
select amount into n2 from tablename
where
month='monthname'
and fy='2010'
return nvl((n2-n1) / n2 * 100,0);
like this you can calculate the diffrence between every month for the year 2009 and 2010
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
