Formula result in %

[Ignbell]

Hi, i need a formula that shows me the result in % but i don´t know how to do
it. my formula is:
([Trabalho]-[Trabalho do Plano Base])/[Trabalho do Plano Base]

Trabalho means Work

Thanks!

 

[Jan De Messemaeker]

Hi,

Multiply by 100
If you need the % sign you have to do that in a Text field, convert to text
and concatenate % behind
HTH

 

[Dale Howard [MVP]]

Ignbell --

Work - Baseline Work = Work Variance

Therefore, put the following formula in a Number field:

[Work Variance]/[Baseline Work]

This will reveal your % of Work that is over or under its original Baseline
budget. For example, I baselined a task at 40 hours of Work (Baseline Work
= 40h). Currently, the Work = 48 hours. Therefore:

Work Variance = Work - Baseline Work
Work Variance = 48 - 40
Work Variance = 8
% Over Budget = 8/40 = .20

You will see the .20 in the Number field. If you want the percent sign to
show up in the result, then you need to use the following formula in a Text
field instead:

([Work Variance]/[Baseline Work] * 100) & "%"

Hope this helps.

 

[Ignbell]

Dave, thanks for your help
With the formula i receive the result in % but i receive a 2.2222222222E-02%
Is there a way that i can only get a round result, i mean 2% or -2%?

Thanks again for the faste response too!.
Nacio.

Ignbell --

Work - Baseline Work = Work Variance

Therefore, put the following formula in a Number field:

[Work Variance]/[Baseline Work]

This will reveal your % of Work that is over or under its original Baseline
budget. For example, I baselined a task at 40 hours of Work (Baseline Work
= 40h). Currently, the Work = 48 hours. Therefore:

Work Variance = Work - Baseline Work
Work Variance = 48 - 40
Work Variance = 8
% Over Budget = 8/40 = .20

You will see the .20 in the Number field. If you want the percent sign to
show up in the result, then you need to use the following formula in a Text
field instead:

([Work Variance]/[Baseline Work] * 100) & "%"

Hope this helps.

Hi, i need a formula that shows me the result in % but i don´t know how to
do
it. my formula is:
([Trabalho]-[Trabalho do Plano Base])/[Trabalho do Plano Base]

Trabalho means Work

Thanks!

 

[Ignbell]

Dale, i found out that if i get the hole formula like this it does give me
int numbers.

EXample: Int (Formula) & "%"

Thanks Dale and Jan, Both answered correctly and really fast, i love this
forum!

Nacio.

Ignbell --

Work - Baseline Work = Work Variance

Therefore, put the following formula in a Number field:

[Work Variance]/[Baseline Work]

This will reveal your % of Work that is over or under its original Baseline
budget. For example, I baselined a task at 40 hours of Work (Baseline Work
= 40h). Currently, the Work = 48 hours. Therefore:

Work Variance = Work - Baseline Work
Work Variance = 48 - 40
Work Variance = 8
% Over Budget = 8/40 = .20

You will see the .20 in the Number field. If you want the percent sign to
show up in the result, then you need to use the following formula in a Text
field instead:

([Work Variance]/[Baseline Work] * 100) & "%"

Hope this helps.

Hi, i need a formula that shows me the result in % but i don´t know how to
do
it. my formula is:
([Trabalho]-[Trabalho do Plano Base])/[Trabalho do Plano Base]

Trabalho means Work

Thanks!

 

[Ignbell]

Dale, sorry to boder you again, is there any reason why this formula doesn´t
work if i make it a Project text formula in PWA. Works perfectly as a task
text formula in PP.

Int ( ([Trabalho]-[Trabalho do Plano Base])/[Trabalho do Plano Base] ) & "%"

Thanks, nacio.

Ignbell --

Work - Baseline Work = Work Variance

Therefore, put the following formula in a Number field:

[Work Variance]/[Baseline Work]

This will reveal your % of Work that is over or under its original Baseline
budget. For example, I baselined a task at 40 hours of Work (Baseline Work
= 40h). Currently, the Work = 48 hours. Therefore:

Work Variance = Work - Baseline Work
Work Variance = 48 - 40
Work Variance = 8
% Over Budget = 8/40 = .20

You will see the .20 in the Number field. If you want the percent sign to
show up in the result, then you need to use the following formula in a Text
field instead:

([Work Variance]/[Baseline Work] * 100) & "%"

Hope this helps.

Hi, i need a formula that shows me the result in % but i don´t know how to
do
it. my formula is:
([Trabalho]-[Trabalho do Plano Base])/[Trabalho do Plano Base]

Trabalho means Work

Thanks!

 

[Dale Howard [MVP]]

Ignbell --

Open a project, press the F9 function key to recalculate the project, and
then save it and publish it. That should resolve the problem. Hope this
helps.

Dale, sorry to boder you again, is there any reason why this formula
doesn´t
work if i make it a Project text formula in PWA. Works perfectly as a task
text formula in PP.

Int ( ([Trabalho]-[Trabalho do Plano Base])/[Trabalho do Plano Base] ) &
"%"

Thanks, nacio.

Ignbell --

Work - Baseline Work = Work Variance

Therefore, put the following formula in a Number field:

[Work Variance]/[Baseline Work]

This will reveal your % of Work that is over or under its original
Baseline
budget. For example, I baselined a task at 40 hours of Work (Baseline
Work
= 40h). Currently, the Work = 48 hours. Therefore:

Work Variance = Work - Baseline Work
Work Variance = 48 - 40
Work Variance = 8
% Over Budget = 8/40 = .20

You will see the .20 in the Number field. If you want the percent sign
to
show up in the result, then you need to use the following formula in a
Text
field instead:

([Work Variance]/[Baseline Work] * 100) & "%"

Hope this helps.

Hi, i need a formula that shows me the result in % but i don´t know how
to
do
it. my formula is:
([Trabalho]-[Trabalho do Plano Base])/[Trabalho do Plano Base]

Trabalho means Work

Thanks!

 

[Ignbell]

My problem is that the Proyect custom field with the formula shows an error
message in Projecto Professional. If i create a local Custom Feld with the
same formula works fine. if i press f9 and republish it it wont change cause
the project custom field will keep on giving me an error message.
Thanks
nacio.

Ignbell --

Open a project, press the F9 function key to recalculate the project, and
then save it and publish it. That should resolve the problem. Hope this
helps.

Dale, sorry to boder you again, is there any reason why this formula
doesn´t
work if i make it a Project text formula in PWA. Works perfectly as a task
text formula in PP.

Int ( ([Trabalho]-[Trabalho do Plano Base])/[Trabalho do Plano Base] ) &
"%"

Thanks, nacio.

Ignbell --

Work - Baseline Work = Work Variance

Therefore, put the following formula in a Number field:

[Work Variance]/[Baseline Work]

This will reveal your % of Work that is over or under its original
Baseline
budget. For example, I baselined a task at 40 hours of Work (Baseline
Work
= 40h). Currently, the Work = 48 hours. Therefore:

Work Variance = Work - Baseline Work
Work Variance = 48 - 40
Work Variance = 8
% Over Budget = 8/40 = .20

You will see the .20 in the Number field. If you want the percent sign
to
show up in the result, then you need to use the following formula in a
Text
field instead:

([Work Variance]/[Baseline Work] * 100) & "%"

Hope this helps.




Hi, i need a formula that shows me the result in % but i don´t know how
to
do
it. my formula is:
([Trabalho]-[Trabalho do Plano Base])/[Trabalho do Plano Base]

Trabalho means Work

Thanks!

 

[Dale Howard [MVP]]

Ignbell --

If you don't baseline the project, it will always trigger an error. Is the
project baselined?

My problem is that the Proyect custom field with the formula shows an
error
message in Projecto Professional. If i create a local Custom Feld with
the
same formula works fine. if i press f9 and republish it it wont change
cause
the project custom field will keep on giving me an error message.
Thanks
nacio.

Ignbell --

Open a project, press the F9 function key to recalculate the project, and
then save it and publish it. That should resolve the problem. Hope this
helps.

Dale, sorry to boder you again, is there any reason why this formula
doesn´t
work if i make it a Project text formula in PWA. Works perfectly as a
task
text formula in PP.

Int ( ([Trabalho]-[Trabalho do Plano Base])/[Trabalho do Plano Base] )
&
"%"

Thanks, nacio.

:

Ignbell --

Work - Baseline Work = Work Variance

Therefore, put the following formula in a Number field:

[Work Variance]/[Baseline Work]

This will reveal your % of Work that is over or under its original
Baseline
budget. For example, I baselined a task at 40 hours of Work (Baseline
Work
= 40h). Currently, the Work = 48 hours. Therefore:

Work Variance = Work - Baseline Work
Work Variance = 48 - 40
Work Variance = 8
% Over Budget = 8/40 = .20

You will see the .20 in the Number field. If you want the percent
sign
to
show up in the result, then you need to use the following formula in a
Text
field instead:

([Work Variance]/[Baseline Work] * 100) & "%"

Hope this helps.




Hi, i need a formula that shows me the result in % but i don´t know
how
to
do
it. my formula is:
([Trabalho]-[Trabalho do Plano Base])/[Trabalho do Plano Base]

Trabalho means Work

Thanks!

 

[Ignbell]

Dave,
Thanks again, i know so much about project that i had to study what
a baselined project was , Now the formula works fine!

Ignbell

Ignbell --

If you don't baseline the project, it will always trigger an error. Is the
project baselined?

My problem is that the Proyect custom field with the formula shows an
error
message in Projecto Professional. If i create a local Custom Feld with
the
same formula works fine. if i press f9 and republish it it wont change
cause
the project custom field will keep on giving me an error message.
Thanks
nacio.

Ignbell --

Open a project, press the F9 function key to recalculate the project, and
then save it and publish it. That should resolve the problem. Hope this
helps.




Dale, sorry to boder you again, is there any reason why this formula
doesn´t
work if i make it a Project text formula in PWA. Works perfectly as a
task
text formula in PP.

Int ( ([Trabalho]-[Trabalho do Plano Base])/[Trabalho do Plano Base] )
&
"%"

Thanks, nacio.

:

Ignbell --

Work - Baseline Work = Work Variance

Therefore, put the following formula in a Number field:

[Work Variance]/[Baseline Work]

This will reveal your % of Work that is over or under its original
Baseline
budget. For example, I baselined a task at 40 hours of Work (Baseline
Work
= 40h). Currently, the Work = 48 hours. Therefore:

Work Variance = Work - Baseline Work
Work Variance = 48 - 40
Work Variance = 8
% Over Budget = 8/40 = .20

You will see the .20 in the Number field. If you want the percent
sign
to
show up in the result, then you need to use the following formula in a
Text
field instead:

([Work Variance]/[Baseline Work] * 100) & "%"

Hope this helps.




Hi, i need a formula that shows me the result in % but i don´t know
how
to
do
it. my formula is:
([Trabalho]-[Trabalho do Plano Base])/[Trabalho do Plano Base]

Trabalho means Work

Thanks!

 

[Dale Howard [MVP]]

Ignbell --

You are more than welcome, my friend!

Dave,
Thanks again, i know so much about project that i had to study what
a baselined project was , Now the formula works fine!

Ignbell

Ignbell --

If you don't baseline the project, it will always trigger an error. Is
the
project baselined?

My problem is that the Proyect custom field with the formula shows an
error
message in Projecto Professional. If i create a local Custom Feld with
the
same formula works fine. if i press f9 and republish it it wont change
cause
the project custom field will keep on giving me an error message.
Thanks
nacio.

:

Ignbell --

Open a project, press the F9 function key to recalculate the project,
and
then save it and publish it. That should resolve the problem. Hope
this
helps.




Dale, sorry to boder you again, is there any reason why this formula
doesn´t
work if i make it a Project text formula in PWA. Works perfectly as
a
task
text formula in PP.

Int ( ([Trabalho]-[Trabalho do Plano Base])/[Trabalho do Plano
Base] )
&
"%"

Thanks, nacio.

:

Ignbell --

Work - Baseline Work = Work Variance

Therefore, put the following formula in a Number field:

[Work Variance]/[Baseline Work]

This will reveal your % of Work that is over or under its original
Baseline
budget. For example, I baselined a task at 40 hours of Work
(Baseline
Work
= 40h). Currently, the Work = 48 hours. Therefore:

Work Variance = Work - Baseline Work
Work Variance = 48 - 40
Work Variance = 8
% Over Budget = 8/40 = .20

You will see the .20 in the Number field. If you want the percent
sign
to
show up in the result, then you need to use the following formula
in a
Text
field instead:

([Work Variance]/[Baseline Work] * 100) & "%"

Hope this helps.




Hi, i need a formula that shows me the result in % but i don´t
know
how
to
do
it. my formula is:
([Trabalho]-[Trabalho do Plano Base])/[Trabalho do Plano Base]

Trabalho means Work

Thanks!