Home » Developer & Programmer » Reports & Discoverer » calculation problem (merged)
calculation problem (merged) [message #355111] Wed, 22 October 2008 13:07 Go to next message
aarti81
Messages: 235
Registered: December 2007
Location: USA
Senior Member
Hi All

In a report i have the following fields :

amount Y Y%
$100 $100 100%
$400 $400 100%
$989 $989 100%
$254 $254 100%
tot:$1743 $1743 GRND TOT:400%

Now i have to create a new column (Y%) which gives what percentage of Y is the amount which is 100% , but when i did the cell sum on the new field Y% its giving me 400% instead i want it as 100% any ideas will be of great help.



Thank You All
Help please [message #355115 is a reply to message #355111] Wed, 22 October 2008 13:45 Go to previous messageGo to next message
aarti81
Messages: 235
Registered: December 2007
Location: USA
Senior Member
Dear All

Its an earlier question but want to rephrase it.
I have two fields

amount Y
$100 $100
$200 $200
$300 $300
$400 $400

TOT:1000 TOT:1000

What i want now is a 3rd field which gives the %of Y ie (Y/amount) at the bottom.

amount Y Y%
$100 $100
$200 $200
$300 $300
$400 $400

TOT:1000 TOT:1000 100%

Any help is greatly appreciated. Thanks
Re: Help please [message #355119 is a reply to message #355115] Wed, 22 October 2008 14:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't multipost your question.
Divide the value by the sum and multiply by 100.

Regards
Michel

[Updated on: Wed, 22 October 2008 14:03]

Report message to a moderator

Re: Help please [message #355127 is a reply to message #355119] Wed, 22 October 2008 14:56 Go to previous messageGo to next message
aarti81
Messages: 235
Registered: December 2007
Location: USA
Senior Member
To be frank i didnt understand the solution as i wanted the Y% at the bottom of the column and i knw i can get it by doing (Y/AMNT)*100, thats the reason i posted again as i didnt explain myself clearly.Here is the problem
AMNT Y Y%
100 100 100%
150 150 100%
600 600 100%
700 0 0
800 0 0
Tot:2350 Tot:850 300%

But actually if you do (850/2350)*100=36.17% and thats what i want as the grand total for the Y%.Any help is greatly appreciated.

Thanks
Michel Cadot wrote on Wed, 22 October 2008 14:03
Don't multipost your question.
Divide the value by the sum and multiply by 100.

Regards
Michel


Re: calculation problem (merged) [message #355190 is a reply to message #355111] Thu, 23 October 2008 01:19 Go to previous message
dude4084
Messages: 221
Registered: March 2005
Location: Mux
Senior Member
so the problem is basically defining formula for GRND TOT
Quote:

amount Y Y%
$100 $100 100%
$400 $400 100%
$989 $989 100%
$254 $254 100%
tot:$1743 $1743 GRND TOT:400%



I suggest you to use (sum of Y/ sum of amount)*100 as formula of GRND TOT instead of sum of Y%.


This will solve your problem.

-Dude
Previous Topic: jpg image format in reports 6i
Next Topic: format triggers
Goto Forum:
  


Current Time: Sat Dec 03 07:45:51 CST 2016

Total time taken to generate the page: 0.10569 seconds