I cannot get a formula to calculate to a percentage. I am dividing my two
varibales which gives me a decimal, then I want to convert it to a
percentage. Everytime I try I either get 0% calculated or syntax error.
What am I missing? Thanks in advance, this list always comes through for
me!!
Can you please describe more in detail your formula ? I don’t understand -
neither don’t you I guess ! - why it doesn’t work.
Here are a couple of things I have tried:
I created a varible that divides the two measures and then I try to do a
format number:
=FormatNumber(< Measure> ,“##%”) this results in 0%
I can get the percent by just changing the format of the cell, but I need to
concatenate a text string and therefore the format cell doesn’t work.
I have also tried just using the % in the lengthy formula string:
=Count(<Object(Data Provider1)>)/Count(<Object(Data Provider)>) %
However, anywhere that I put the % gives me a syntax error, I have tried ()
but I am probably doing it incorrectly. Help.
From: Christophe GROS[SMTP:CGROS@SANDERS.FR]
Sent: Thursday, January 07, 1999 2:14 AM
Michele,
I cannot get a formula to calculate to a percentage. I am dividing my
two
varibales which gives me a decimal, then I want to convert it to a
percentage. Everytime I try I either get 0% calculated or syntax error.
What am I missing? Thanks in advance, this list always comes through for
me!!
Can you please describe more in detail your formula ? I don’t understand -
neither don’t you I guess ! - why it doesn’t work.
I found a cheap work around ( I multiply by 100 and then add a text
statement with “%” so it appears to be a percent…its not pretty but…
Here are a couple of things I have tried:
I created a varible that divides the two measures and then I try to do a
format number:
=FormatNumber(< Measure> ,“##%”) this results in 0%
I can get the percent by just changing the format of the cell, but I need
to concatenate a text string and therefore the format cell doesn’t work.
I have also tried just using the % in the lengthy formula string:
=Count(<Object(Data Provider1)>)/Count(<Object(Data Provider)>) %
However, anywhere that I put the % gives me a syntax error, I have tried
() but I am probably doing it incorrectly. Help.
From: Christophe GROS[SMTP:CGROS@SANDERS.FR]
Sent: Thursday, January 07, 1999 2:14 AM
Michele,
I cannot get a formula to calculate to a percentage. I am dividing my
two
varibales which gives me a decimal, then I want to convert it to a
percentage. Everytime I try I either get 0% calculated or syntax error.
What am I missing? Thanks in advance, this list always comes through for
me!!
Can you please describe more in detail your formula ? I don’t understand -
neither don’t you I guess ! - why it doesn’t work.
Expanding on your formula should work fine:
=FormatNumber(< Measure> ,"##%") & " any text here"
You could also try something more simple:
= + “%” + " any text here"
I’m sure there are other solutions…
In short, you should be able to concatenate a text string to your current
formula.
Cheers,
Luis Gonzalez
-----Original Message-----
Sent: Thursday, January 07, 1999 09:46 AM
Here are a couple of things I have tried:
I created a varible that divides the two measures and then I
try to do a
format number:
=FormatNumber(< Measure> ,"##%") this results in 0%
I can get the percent by just changing the format of the
cell, but I need to
concatenate a text string and therefore the format cell
doesn’t work.
I have also tried just using the % in the lengthy formula
string:
=Count(<Object(Data Provider1)>)/Count(<Object(Data
Provider)>) %
However, anywhere that I put the % gives me a syntax error,
I have tried ()
but I am probably doing it incorrectly. Help.