OraFAQ Forum: Reports & Discoverer » difficult calculation

Home » Developer & Programmer » Reports & Discoverer » difficult calculation (disc 10.1.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

difficult calculation [message #400958]

Thu, 30 April 2009 12:28

aarti81
Messages: 235
Registered: December 2007
Location: USA

Senior Member

Hi All
I have a report with the following fields and calculations

Quarter Month Estimate_Amnt Awarded_ Amnt 
Q1 JUL $1000 $800
AUG $2000 $1800
SEP $500 $300

Q2

Q3


Q4

And i have two totals one on the estimated amount and the other on the awarded amount for every change in the Quarter and two more Grand totals on the Estimate and awarded amount.
Now i want to create a new calculation like the following:

Q1(ESTIMATE TOTATAL)/Grand (ESTIMATE TOTAL) for each Quarters Q1,Q2,Q3,Q4. Please any advice or help is greatly appreciated.

Thanks

Quote:

Report message to a moderator

Previous Topic:	system parameter
Next Topic:	how to make Opening balance plus page total as carry forward on page

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 03:57:19 CST 2024