| calculation problem (merged) [message #355111] |
Wed, 22 October 2008 13:07  |
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  |
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 #355127 is a reply to message #355119] |
Wed, 22 October 2008 14:56 |
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 |
dude4084
Messages: 222
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
