Graphical Project Text Custom field from a Baselined custom field.

[Ignbell]

Hi,
I have a problema making the Graphical custom fields for the result of this
formula for Desvio de horas: (([Trabalho]-[Trabalho do Plano
Base])/[Trabalho do Plano Base] )*100 & "%".
"Trabalho" means work, and "Trabalho do plano base" is a baselined value.
I used the following formula to show different faces for the value of
another`s proyects "% Complete" field and works fine, but i`m trying to use
the same formula for this field but it doesn`t show any result at all, with
or without the graphics. I don´t know if it has something to do whith the
result cause it´s in "%"
or if it isnt an entire number or even if it is beacause the formula of
"Desvio de horas" is using a baselined customfield to calculate it
Switch([Desvio de horas]=0,"1",[Desvio de horas]<=10,"2",[Desvio de
horas]>10,"3")

I`d appreciate any help. Thanks!!
Ignbell.

 

[Ignbell]

Hi again,
I found out that if i just make my formula the following way i´ll
get te graphics working,

Switch([Desvio de horas]=0 & "%","1",[Desvio de horas]>10 & "%","3",[Desvio
de horas]<=10 & "%","2")

The problem is that number "2" only comes out when the result is betwen 0.5%
and 1.5% and when i get exactly 10% and any negative number. Don´t get it
with 100% 1000%

Can anyone help me make a formula where i get the "1" value when the result
es equal to 0, "2" when the result is >=1% and <=10% and "3" when the result
is >10%? Thanks..

Ignbell

 

[Dave]

Presumably, since it contains the character "%", Desvio de horas is a
text field. Consequently, in order to perform mathematic operations on
it, you will need to convert it to a number. For clarity, it is
probably best to use an additional number field for this:

Val( Left( [Desvio de horas] , Len( [Desvio de horas] ) - 1 ) )

In order to make sure the value is always positive, use the Abs() function:

Abs( ... )

Now your requirement is not well formed as you don't say what you want
to happen when the result is greater than 0 but less than 1. Also I
would suggest that the likelihood of the deviation from the baseline
being exactly 0 is about 0 itself. So the expression I give performs as
follows:
Returns 1 if the deviation is less than 1%
Returns 2 if the deviation is greater than 1% but less than or equal to 10%
Returns 3 otherwise.

The formula is:

Switch( [Number2] < 1 , 1 , [Number2] <= 10 , 2 , [Number2] > 10 , 3 )

Now the graphical indicators will work.

Hi again,
I found out that if i just make my formula the following way i´ll
get te graphics working,

Switch([Desvio de horas]=0 & "%","1",[Desvio de horas]>10 & "%","3",[Desvio
de horas]<=10 & "%","2")

The problem is that number "2" only comes out when the result is betwen 0.5%
and 1.5% and when i get exactly 10% and any negative number. Don´t get it
with 100% 1000%

Can anyone help me make a formula where i get the "1" value when the result
es equal to 0, "2" when the result is >=1% and <=10% and "3" when the result
is >10%? Thanks..

Ignbell


:

Hi,
I have a problema making the Graphical custom fields for the result of this
formula for Desvio de horas: (([Trabalho]-[Trabalho do Plano
Base])/[Trabalho do Plano Base] )*100 & "%".
"Trabalho" means work, and "Trabalho do plano base" is a baselined value.
I used the following formula to show different faces for the value of
another`s proyects "% Complete" field and works fine, but i`m trying to use
the same formula for this field but it doesn`t show any result at all, with
or without the graphics. I don´t know if it has something to do whith the
result cause it´s in "%"
or if it isnt an entire number or even if it is beacause the formula of
"Desvio de horas" is using a baselined customfield to calculate it
Switch([Desvio de horas]=0,"1",[Desvio de horas]<=10,"2",[Desvio de
horas]>10,"3")

I`d appreciate any help. Thanks!!
Ignbell.