ADD PERCENT SYMBOL TO A FORMULA

[dyb]

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

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

 

[DYB]

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
HT

-
Jan De Messemaeke
Microsoft Project Most Valuable Professiona
http://users.online.be/prom-ade/index.ht
32-495-300 62

Thanks #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

dyb -
Use the convert to string function and concatenate the percent sig

to th
result of the formula, such as

cStr(20/500*100 & "%"
Hope this help
-

Dale A. Howard [MVP
Enterprise Project Trainer/Consultan
http://www.msprojectexperts.co
"We wrote the book on Project Server

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

 

[Jan De Messemaeker]

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
http://users.online.be/prom-ade/index.htm
32-495-300 620

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
http://users.online.be/prom-ade/index.htm
32-495-300 620

Thanks.

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.

percent sign
to the

result of the formula, such as:
Dale A. Howard [MVP]
Enterprise Project Trainer/Consultant
http://www.msprojectexperts.com
"We wrote the book on Project Server"

 

[JackD]

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

-Jack

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
http://users.online.be/prom-ade/index.htm
32-495-300 620

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
http://users.online.be/prom-ade/index.htm
32-495-300 620

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

 

[DYB]

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

-Jac

Hi

OK, I should have tried, or anybody could have tried.

This works
(CStr([Actual Cost]*100/[Baseline Cost])) & "%

Greeting
-

Jan De Messemaeke
Microsoft Project Most Valuable Professiona
http://users.online.be/prom-ade/index.ht
32-495-300 62

----- Jan De Messemaeker wrote: ---- it
Jan De Messemaeke
Microsoft Project Most Valuable Professiona
http://users.online.be/prom-ade/index.ht
32-495-300 62

kee

gettin
#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 th

percent sig
to th

result of the formula, such as
cStr(20/500*100 & "%"
Hope this help
-
Dale A. Howard [MVP
Enterprise Project Trainer/Consultan
http://www.msprojectexperts.co
"We wrote the book on Project Server
How do I add the % symbol to a custom formula in Project 200
e.g. 20/500*100 = 4