How do I add the % symbol to a custom formula in Project 2002

e.g. 20/500*100 = 4 %

dyb --

Use the convert to string function and concatenate the percent sign to the
result of the formula, such as:

cStr(20/500*100 & "%")

Hope this helps

--
Dale A. Howard [MVP]
Enterprise Project Trainer/Consultant
[url]http://www.msprojectexperts.com[/url]
"We wrote the book on Project Server"


"dyb" <anonymous@discussions.microsoft.com> wrote in message
news:97E02EC7-D932-4972-8479-E276FA96CBA4@microsoft.com...
> How do I add the % symbol to a custom formula in Project 2002
>
> e.g. 20/500*100 = 4 %

Thanks.

I've tried suggestion below several times with no success. I keep getting #ERROR message.
In general and specifically, I'm trying to derive a formula for % SPENT = cStr([Actual Cost]/[Baseline Cost]*100 & "%").
The formula works okay without the cstr string.
Any additional help would be helpful.


----- Dale Howard [MVP] wrote: -----

dyb --

Use the convert to string function and concatenate the percent sign to the
result of the formula, such as:

cStr(20/500*100 & "%")

Hope this helps

--
Dale A. Howard [MVP]
Enterprise Project Trainer/Consultant
[url]http://www.msprojectexperts.com[/url]
"We wrote the book on Project Server"


"dyb" <anonymous@discussions.microsoft.com> wrote in message
news:97E02EC7-D932-4972-8479-E276FA96CBA4@microsoft.com...
> How do I add the % symbol to a custom formula in Project 2002
>> e.g. 20/500*100 = 4 %

Hi,

Move the closing parenthesis to just after the 100, that should do it.
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
[url]http://users.online.be/prom-ade/index.htm[/url]
32-495-300 620
"dyb" <anonymous@discussions.microsoft.com> schreef in bericht
news:8744B434-A40A-484B-AD6E-AC14C8D60F2E@microsoft.com...
> Thanks.
>
> I've tried suggestion below several times with no success. I keep getting
#ERROR message.
> In general and specifically, I'm trying to derive a formula for % SPENT =
cStr([Actual Cost]/[Baseline Cost]*100 & "%").
> The formula works okay without the cstr string.
> Any additional help would be helpful.
>
>
> ----- Dale Howard [MVP] wrote: -----
>
> dyb --
>
> Use the convert to string function and concatenate the percent sign
to the
> result of the formula, such as:
>
> cStr(20/500*100 & "%")
>
> Hope this helps
>
> --
> Dale A. Howard [MVP]
> Enterprise Project Trainer/Consultant
> [url]http://www.msprojectexperts.com[/url]
> "We wrote the book on Project Server"
>
>
> "dyb" <anonymous@discussions.microsoft.com> wrote in message
> news:97E02EC7-D932-4972-8479-E276FA96CBA4@microsoft.com...
> > How do I add the % symbol to a custom formula in Project 2002
> >> e.g. 20/500*100 = 4 %
>
>
>

Thanks for the continuing assistance.

Unfortunately, no luck yet. I'm still getting the #ERROR message.

Any additional suggestion?. Perhaps, someone could try the formula noted below.

Thanks.
----- Jan De Messemaeker wrote: -----

Hi,

Move the closing parenthesis to just after the 100, that should do it.
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
[url]http://users.online.be/prom-ade/index.htm[/url]
32-495-300 620
"dyb" <anonymous@discussions.microsoft.com> schreef in bericht
news:8744B434-A40A-484B-AD6E-AC14C8D60F2E@microsoft.com...
> Thanks.
>> I've tried suggestion below several times with no success. I keep getting
#ERROR message.
> In general and specifically, I'm trying to derive a formula for % SPENT =
cStr([Actual Cost]/[Baseline Cost]*100 & "%").
> The formula works okay without the cstr string.
> Any additional help would be helpful.
>>> ----- Dale Howard [MVP] wrote: -----
>> dyb --
>> Use the convert to string function and concatenate the percent sign
to the
> result of the formula, such as:
>> cStr(20/500*100 & "%")
>> Hope this helps
>> --
> Dale A. Howard [MVP]
> Enterprise Project Trainer/Consultant
> [url]http://www.msprojectexperts.com[/url]
> "We wrote the book on Project Server"
>>> "dyb" <anonymous@discussions.microsoft.com> wrote in message
> news:97E02EC7-D932-4972-8479-E276FA96CBA4@microsoft.com...
>> How do I add the % symbol to a custom formula in Project 2002
>>> e.g. 20/500*100 = 4 %
>>>

Hi,

OK, I should have tried, or anybody could have tried..
This works:
(CStr([Actual Cost]*100/[Baseline Cost])) & "%"

Greetings

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
[url]http://users.online.be/prom-ade/index.htm[/url]
32-495-300 620
"DYB" <anonymous@discussions.microsoft.com> schreef in bericht
news:719E9C61-1BED-43DF-80B9-B257136E6C5C@microsoft.com...
>
> Thanks for the continuing assistance.
>
> Unfortunately, no luck yet. I'm still getting the #ERROR message.
>
> Any additional suggestion?. Perhaps, someone could try the formula noted
below.
>
> Thanks.
> ----- Jan De Messemaeker wrote: -----
>
> Hi,
>
> Move the closing parenthesis to just after the 100, that should do
it.
> HTH
>
> --
> Jan De Messemaeker
> Microsoft Project Most Valuable Professional
> [url]http://users.online.be/prom-ade/index.htm[/url]
> 32-495-300 620
> "dyb" <anonymous@discussions.microsoft.com> schreef in bericht
> news:8744B434-A40A-484B-AD6E-AC14C8D60F2E@microsoft.com...
> > Thanks.
> >> I've tried suggestion below several times with no success. I keep
getting
> #ERROR message.
> > In general and specifically, I'm trying to derive a formula for %
SPENT =
> cStr([Actual Cost]/[Baseline Cost]*100 & "%").
> > The formula works okay without the cstr string.
> > Any additional help would be helpful.
> >>> ----- Dale Howard [MVP] wrote: -----
> >> dyb --
> >> Use the convert to string function and concatenate the
percent sign
> to the
> > result of the formula, such as:
> >> cStr(20/500*100 & "%")
> >> Hope this helps
> >> --
> > Dale A. Howard [MVP]
> > Enterprise Project Trainer/Consultant
> > [url]http://www.msprojectexperts.com[/url]
> > "We wrote the book on Project Server"
> >>> "dyb" <anonymous@discussions.microsoft.com> wrote in message

> > news:97E02EC7-D932-4972-8479-E276FA96CBA4@microsoft.com...
> >> How do I add the % symbol to a custom formula in Project 2002
> >>> e.g. 20/500*100 = 4 %
> >>>

Note that this needs to be in a TEXT field to work.
Not in a number or cost field.

-Jack


"Jan De Messemaeker" <jandemes at prom hyphen ade dot be> wrote in message
news:%23PV9dM6KEHA.2576@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> OK, I should have tried, or anybody could have tried..
> This works:
> (CStr([Actual Cost]*100/[Baseline Cost])) & "%"
>
> Greetings
>
> --
> Jan De Messemaeker
> Microsoft Project Most Valuable Professional
> [url]http://users.online.be/prom-ade/index.htm[/url]
> 32-495-300 620
> "DYB" <anonymous@discussions.microsoft.com> schreef in bericht
> news:719E9C61-1BED-43DF-80B9-B257136E6C5C@microsoft.com...
> >
> > Thanks for the continuing assistance.
> >
> > Unfortunately, no luck yet. I'm still getting the #ERROR message.
> >
> > Any additional suggestion?. Perhaps, someone could try the formula noted
> below.
> >
> > Thanks.
> > ----- Jan De Messemaeker wrote: -----
> >
> > Hi,
> >
> > Move the closing parenthesis to just after the 100, that should do
> it.
> > HTH
> >
> > --
> > Jan De Messemaeker
> > Microsoft Project Most Valuable Professional
> > [url]http://users.online.be/prom-ade/index.htm[/url]
> > 32-495-300 620
> > "dyb" <anonymous@discussions.microsoft.com> schreef in bericht
> > news:8744B434-A40A-484B-AD6E-AC14C8D60F2E@microsoft.com...
> > > Thanks.
> > >> I've tried suggestion below several times with no success. I
keep
> getting
> > #ERROR message.
> > > In general and specifically, I'm trying to derive a formula for %
> SPENT =
> > cStr([Actual Cost]/[Baseline Cost]*100 & "%").
> > > The formula works okay without the cstr string.
> > > Any additional help would be helpful.
> > >>> ----- Dale Howard [MVP] wrote: -----
> > >> dyb --
> > >> Use the convert to string function and concatenate the
> percent sign
> > to the
> > > result of the formula, such as:
> > >> cStr(20/500*100 & "%")
> > >> Hope this helps
> > >> --
> > > Dale A. Howard [MVP]
> > > Enterprise Project Trainer/Consultant
> > > [url]http://www.msprojectexperts.com[/url]
> > > "We wrote the book on Project Server"
> > >>> "dyb" <anonymous@discussions.microsoft.com> wrote in
message
>
> > > news:97E02EC7-D932-4972-8479-E276FA96CBA4@microsoft.com...
> > >> How do I add the % symbol to a custom formula in Project 2002
> > >>> e.g. 20/500*100 = 4 %
> > >>>
>
>

Thanks. It works as noted.

----- JackD wrote: -----

Note that this needs to be in a TEXT field to work.
Not in a number or cost field.

-Jack


"Jan De Messemaeker" <jandemes at prom hyphen ade dot be> wrote in message
news:%23PV9dM6KEHA.2576@TK2MSFTNGP12.phx.gbl...
> Hi,
>> OK, I should have tried, or anybody could have tried..
> This works:
> (CStr([Actual Cost]*100/[Baseline Cost])) & "%"
>> Greetings
>> --
> Jan De Messemaeker
> Microsoft Project Most Valuable Professional
> [url]http://users.online.be/prom-ade/index.htm[/url]
> 32-495-300 620
> "DYB" <anonymous@discussions.microsoft.com> schreef in bericht
> news:719E9C61-1BED-43DF-80B9-B257136E6C5C@microsoft.com...
>>>> Thanks for the continuing assistance.
>>>> Unfortunately, no luck yet. I'm still getting the #ERROR message.
>>>> Any additional suggestion?. Perhaps, someone could try the formula noted
> below.
>>>> Thanks.
>> ----- Jan De Messemaeker wrote: -----
>>>> Hi,
>>>> Move the closing parenthesis to just after the 100, that should do
> it.
>> HTH
>>>> --
>> Jan De Messemaeker
>> Microsoft Project Most Valuable Professional
>> [url]http://users.online.be/prom-ade/index.htm[/url]
>> 32-495-300 620
>> "dyb" <anonymous@discussions.microsoft.com> schreef in bericht
>> news:8744B434-A40A-484B-AD6E-AC14C8D60F2E@microsoft.com...
>>> Thanks.
>>>> I've tried suggestion below several times with no success. I
keep
> getting
>> #ERROR message.
>>> In general and specifically, I'm trying to derive a formula for %
> SPENT =
>> cStr([Actual Cost]/[Baseline Cost]*100 & "%").
>>> The formula works okay without the cstr string.
>>> Any additional help would be helpful.
>>>>> ----- Dale Howard [MVP] wrote: -----
>>>> dyb --
>>>> Use the convert to string function and concatenate the
> percent sign
>> to the
>>> result of the formula, such as:
>>>> cStr(20/500*100 & "%")
>>>> Hope this helps
>>>> --
>>> Dale A. Howard [MVP]
>>> Enterprise Project Trainer/Consultant
>>> [url]http://www.msprojectexperts.com[/url]
>>> "We wrote the book on Project Server"
>>>>> "dyb" <anonymous@discussions.microsoft.com> wrote in
message
>>>> news:97E02EC7-D932-4972-8479-E276FA96CBA4@microsoft.com...
>>>> How do I add the % symbol to a custom formula in Project 2002
>>>>> e.g. 20/500*100 = 4 %
>>>>>>>