Home » Developer & Programmer » Reports & Discoverer » need help (disc 10.1.2)
need help [message #430483] Tue, 10 November 2009 10:57 Go to next message
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 Go to previous message
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
Previous Topic: No timeout in BI Excel Add-In or D4O
Next Topic: To call explicit parameters to Discoverer Folder in Disco Admin
Goto Forum:
  


Current Time: Thu Sep 29 00:30:34 CDT 2016

Total time taken to generate the page: 0.11771 seconds