Format a number into %

[TroyS]

I have a task formula:

IF([baseline work]=0,0,[actual work]/[baseline work])

I'm trying to get so that the output is #.#% and displayed as such in the
project schedule.

I've tried:
format([formula_above],"#0.#%") but i get #Error and i've tried Format()
around the 0 and the ([actual work]/[baseline work]) but still get #Error.

I'm sure it's something simple.....thx.

 

[Marc Soester]

Hi TroyS,

use a text field with the following formular:
IIf([Baseline Work]=0,0,[Actual Work]/[Baseline Work]) & "%"
That should fix the problem
Hope this helps

 

[TroyS]

Marc,
yes that worked. thx.

Hi TroyS,

use a text field with the following formular:
IIf([Baseline Work]=0,0,[Actual Work]/[Baseline Work]) & "%"
That should fix the problem
Hope this helps
--
Marc Soester
State Manager: EPM

I have a task formula:

IF([baseline work]=0,0,[actual work]/[baseline work])

I'm trying to get so that the output is #.#% and displayed as such in the
project schedule.

I've tried:
format([formula_above],"#0.#%") but i get #Error and i've tried Format()
around the 0 and the ([actual work]/[baseline work]) but still get #Error.

I'm sure it's something simple.....thx.