Home » Developer & Programmer » Reports & Discoverer » difficult calculation (disc 10.1.2)
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:

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


Current Time: Thu Mar 28 16:07:29 CDT 2024