need help getting a formula to work

[chris]

I have a custom NUMBER field num1 with a formula that is based on a custom FLAG field (flag1) and I want to have a graphical indicator based on the result of num1 only when its true. The formula I have for NUM1 is
IIf([Flag1]=Yes,[Finish]-[Start],-1
Then for the graphical indicator I hav
equal zero -> indicator
less than or equal to # -> indicator
greater than # -> indicator
less than 0 -> indicator D = blan
However, I'm not getting what I want. I want the indicator to be blank if the flag is No ie; returned the falsepart -1 ? Can anyone help with getting the formula right for what I want

 

[Dale Howard [MVP]]

Chris --

Why don't you just use another custom Flag field, such as Flag2, and enter
the formula simply as: [Flag1]? Then set your test for the graphical
indicators in the Flag1 field based on either a True or a False value, or a
Yes or No value. It would be a lot simpler. Hope this helps.

I have a custom NUMBER field num1 with a formula that is based on a custom

FLAG field (flag1) and I want to have a graphical indicator based on the
result of num1 only when its true. The formula I have for NUM1 is

IIf([Flag1]=Yes,[Finish]-[Start],-1)
Then for the graphical indicator I have
equal zero -> indicator A
less than or equal to # -> indicator B
greater than # -> indicator C
less than 0 -> indicator D = blank
However, I'm not getting what I want. I want the indicator to be blank if

the flag is No ie; returned the falsepart -1 ? Can anyone help with getting
the formula right for what I want ?

 

[chris]

The problem is I really want more than one choice which is why I chose the number. I want a red-yellow-green indicator.

 

[John Beamish]

1. RightMouseButton on the Number1 field
2. Click on Customize Field ...

In the popup dialog
3. Click on the Formula button and enter your formula (it's a strange one
so I've chosen something different)

datediff("d", [start], [finish] )

4. Click on the OK button
5. Click on the Graphical Indicators button
6. Select the test, the value and the colour of the indicator.

For example:
is less than, 10, blank
is less than, 20, yellow
is greater than 19, red

Since one of the indicators is blank, you can use that one for the
conditions that do not require a graphical indicator.

Project looks at the first criteria and, if met, sets the indicator and
finishes. If the critia is not met then Project looks at the next
criteria, and so on.

JLB, PMP

The problem is I really want more than one choice which is why I chose
the number. I want a red-yellow-green indicator.

--

 

[JackD]

I have a custom NUMBER field num1 with a formula that is based on a custom

FLAG field (flag1) and I want to have a graphical indicator based on the
result of num1 only when its true. The formula I have for NUM1 is

IIf([Flag1]=Yes,[Finish]-[Start],-1)
Then for the graphical indicator I have
equal zero -> indicator A
less than or equal to # -> indicator B
greater than # -> indicator C
less than 0 -> indicator D = blank
However, I'm not getting what I want. I want the indicator to be blank if

the flag is No ie; returned the falsepart -1 ? Can anyone help with getting
the formula right for what I want ?

Sounds like if the value is -1 then it will get indicator B. Project uses
the first indicator that evaluates to true and stops there. -1 is likely to
be less than or equal to #. Try changing the order or giving a more distinct
value for the blank one.

-Jack