Project Server 2003 Formula Help Requested

[mike]

Hello, working in an '03 environment. Client created an Enterprise
Custom Flag with the following formula
IIf([Enterprise Project Number7]-[Actual Work]>=0,"Yes","No")

Enterprise Project Number 7, is a Project Number that is manully
entered under Project Information.

If Enterprise # 7 - Actual Wk is Greater than or = to 0, they they
would like a green indicator, if not then red.

In my tests, I entered 300 under project information for Enterprise
Number 7. On the actual work on my first task, I entered 120.

In Project Center, I am getting a red indicator. The formula must not
be right, any ideas as to what is should be?

This is the desired outcome:

If Enterprise # 7 - Actual Wk is Greater than or = to 0, they they
would like a green indicator, if not then red.

Thanks

MC

 

[CQ]

Hi Mike,

I think that you are comparing apples to oranges. "Work" is measured as
minutes *1000 (Eight hours would be saved as 480000 (that is, 8*60*1000). )
So, you have to convert your [Actual Work] to whatever measure you are trying
to use.

CQ

 

[mike]

Hi Mike,

I think that you are comparing apples to oranges.  "Work" is measured as
minutes *1000 (Eight hours would be saved as 480000 (that is, 8*60*1000).)  
So, you have to convert your [Actual Work] to whatever measure you are trying
to use.

CQ

Hello, working in an '03 environment.  Client created an Enterprise
Custom Flag with the following formula
IIf([Enterprise Project Number7]-[Actual Work]>=0,"Yes","No")

Enterprise Project Number 7, is a Project Number that is manully
entered under Project Information.

If Enterprise # 7 - Actual Wk is Greater than or = to 0, they they
would like a green indicator, if not then red.

In my tests, I entered 300 under project information for Enterprise
Number 7.  On the actual work on my first task, I entered 120.

In Project Center, I am getting a red indicator.  The formula must not
be right, any ideas as to what is should be?

This is the desired outcome:

If Enterprise # 7 - Actual Wk is Greater than or = to 0, they they
would like a green indicator, if not then red.

MC

CW not sure how to convert Actual Work, I would like to keep it at
hours. My original Enterprise Custom Field 7 was 300 (representing
300 hours) I then perfromed th following 300 *60*1000 and got
18000000 as my new Ent.#7. I am trying to follow you info, and would
have expected the flag to turn red, as soon as I reproted actual work
greater than 300. I reported over 700 so far, everything is green.

 

[mike]

Hi Mike,

I think that you are comparing apples to oranges.  "Work" is measuredas
minutes *1000 (Eight hours would be saved as 480000 (that is, 8*60*1000). )  
So, you have to convert your [Actual Work] to whatever measure you are trying
to use.

CQ

Hello, working in an '03 environment.  Client created an Enterprise
Custom Flag with the following formula
IIf([Enterprise Project Number7]-[Actual Work]>=0,"Yes","No")
Enterprise Project Number 7, is a Project Number that is manully
entered under Project Information.
If Enterprise # 7 - Actual Wk is Greater than or = to 0, they they
would like a green indicator, if not then red.
In my tests, I entered 300 under project information for Enterprise
Number 7.  On the actual work on my first task, I entered 120.
In Project Center, I am getting a red indicator.  The formula must not
be right, any ideas as to what is should be?
This is the desired outcome:
If Enterprise # 7 - Actual Wk is Greater than or = to 0, they they
would like a green indicator, if not then red.
Thanks
MC

CW not sure how to convert Actual Work, I would like to keep it at
hours.  My original Enterprise Custom Field 7 was 300 (representing
300 hours)  I then perfromed th following 300 *60*1000 and got
18000000 as my new Ent.#7.  I am trying to follow you info, and would
have expected the flag to turn red, as soon as I reproted actual work
greater than 300.  I reported over 700 so far, everything is green.

CW, I think I got it. Actual Wk is using miniues (is there any why to
put to hrs?) I took my 30o from Ent 7 * 60 and it gave me 18000, as
my new Ent 7 number. I was green up to 300. The moment I hit 301, it
was red.

Thanks for your input.

MC

 

[CQ]

Hi Mike,

You could convert the actual work to hours just by adding something like
([ActualWork]/60)

Hi Mike,

I think that you are comparing apples to oranges. "Work" is measured as
minutes *1000 (Eight hours would be saved as 480000 (that is, 8*60*1000). )
So, you have to convert your [Actual Work] to whatever measure you are trying
to use.

CQ

:
Hello, working in an '03 environment. Client created an Enterprise
Custom Flag with the following formula
IIf([Enterprise Project Number7]-[Actual Work]>=0,"Yes","No")

Enterprise Project Number 7, is a Project Number that is manully
entered under Project Information.

If Enterprise # 7 - Actual Wk is Greater than or = to 0, they they
would like a green indicator, if not then red.

In my tests, I entered 300 under project information for Enterprise
Number 7. On the actual work on my first task, I entered 120.

In Project Center, I am getting a red indicator. The formula must not
be right, any ideas as to what is should be?

This is the desired outcome:

If Enterprise # 7 - Actual Wk is Greater than or = to 0, they they
would like a green indicator, if not then red.

MC

CW not sure how to convert Actual Work, I would like to keep it at
hours. My original Enterprise Custom Field 7 was 300 (representing
300 hours) I then perfromed th following 300 *60*1000 and got
18000000 as my new Ent.#7. I am trying to follow you info, and would
have expected the flag to turn red, as soon as I reproted actual work
greater than 300. I reported over 700 so far, everything is green.

CW, I think I got it. Actual Wk is using miniues (is there any why to
put to hrs?) I took my 30o from Ent 7 * 60 and it gave me 18000, as
my new Ent 7 number. I was green up to 300. The moment I hit 301, it
was red.

Thanks for your input.

MC

 

[mike]

Hi Mike,

You could convert the actual work to hours just by adding something like
([ActualWork]/60)

Hi Mike,
I think that you are comparing apples to oranges.  "Work" is measured as
minutes *1000 (Eight hours would be saved as 480000 (that is, 8*60*1000). )  
So, you have to convert your [Actual Work] to whatever measure you are trying
to use.
CQ
:
Hello, working in an '03 environment.  Client created an Enterprise
Custom Flag with the following formula
IIf([Enterprise Project Number7]-[Actual Work]>=0,"Yes","No")
Enterprise Project Number 7, is a Project Number that is manully
entered under Project Information.
If Enterprise # 7 - Actual Wk is Greater than or = to 0, they they
would like a green indicator, if not then red.
In my tests, I entered 300 under project information for Enterprise
Number 7.  On the actual work on my first task, I entered 120.
In Project Center, I am getting a red indicator.  The formula must not
be right, any ideas as to what is should be?
This is the desired outcome:
If Enterprise # 7 - Actual Wk is Greater than or = to 0, they they
would like a green indicator, if not then red.
Thanks
MC
CW not sure how to convert Actual Work, I would like to keep it at
hours.  My original Enterprise Custom Field 7 was 300 (representing
300 hours)  I then perfromed th following 300 *60*1000 and got
18000000 as my new Ent.#7.  I am trying to follow you info, and would
have expected the flag to turn red, as soon as I reproted actual work
greater than 300.  I reported over 700 so far, everything is green.

CW, I think I got it.  Actual Wk is using miniues (is there any why to
put to hrs?)  I took my 30o from Ent 7 * 60 and it gave me 18000, as
my new Ent 7 number.  I was green up to 300.  The moment I hit 301,it
was red.

Thanks for your input.

MC

CQ - Thanks !

I tried to create a new Ent Field and this is where the budget hrs
would go. 300. Then Ent 7 would be a formula ([Ent14]*60) but it
refused to calculate.

I took your suggestion and in my Ent Flag formula now readscorrectly.

Thanks again !

IIf([Enterprise Project Number7]-([Actual Work]/60)>=0,"Yes","No")