Home » Developer & Programmer » Reports & Discoverer » calculation problem (merged)
calculation problem (merged) Wed, 22 October 2008 13:07
 aarti81 Messages: 235Registered: 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
 aarti81 Messages: 235Registered: 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
 Michel Cadot Messages: 65143Registered: March 2007 Location: Nanterre, France, http://... Senior MemberAccount Moderator
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
 aarti81 Messages: 235Registered: 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
 dude4084 Messages: 221Registered: 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%.