Cost Variance Graphical Indicator

[mike.wilson]

I'm using the following formula to display a graphical indicator on
Cost Variance.

IIf([Baseline Cost]=0,4,IIf(([CV%]*100)>15,3,IIf(([CV%]*100)>5,2,1)))

Green = 1
Yellow = 2
Red = 3
White = 4

I want to display a white circle when the Baseline Cost is 0, but I
haven't been ablet to get this to work. Any ideas?

 

[Gaurav Wason]

Mike,

Are you using number field. The formula you wrote I tested it and it works
with number field. Be sure you had the option checked use formula and task is
baselined.

Let me know.

--
Gaurav Wason
(e-mail address removed)
MCP - Project Server
Project Made Easy
Project Archive Tool
Project Owner Tool
http://projectmadeeasy.com

 

[John M.]

As for your "white" indicator, if your intention is to display this when
there is no baseline (as opposed to a 0 baseline) then Dale Howard had an
answer to this in another posting (shown below)...

One way to "trap" the error caused by not baselining the project (or task)
is to use the following:

IIF([Baseline Start]>65000,truevalue,falsevalue)

John M.

 

[mike.wilson]

Yes and No.....I do want to show if a baseline had been saved, but
there will also be cases where costs were not inlcuded in the baseline.
So I might use the stated example to add another indicator, however I
will still need an indicator to show 0 Baseline Cost.

Another question on this topic:
I had seen this on a previous post and was wondering if you (or
someone) can tell me what the 65000 part of the formula meant.

Thanks,
-Mike

 

[John M.]

To the best of my understanding, in project professional, the [Baseline...]
fields are varients that are either dates (when a baseline has been saved)
or are 'NA' when one has not been saved. Unfortunately, you can't do a
check for "NA". The value that the 'NA' has during a comparison is
4,294,967,295 (which happens to be the largest decimal value for 32 bits...
or FFFFFFFF if you prefer hexadecimal). You could do a comparison for the
exact 429... number, but it is easier to just check for a number greater
than something around 65,000 (which I believe is December 16, 2077).

John M.

 

[Gary L. Chefetz [MVP]]

Actually you can test for N/A using the projdateval function

To the best of my understanding, in project professional, the
[Baseline...] fields are varients that are either dates (when a baseline
has been saved) or are 'NA' when one has not been saved. Unfortunately,
you can't do a check for "NA". The value that the 'NA' has during a
comparison is 4,294,967,295 (which happens to be the largest decimal value
for 32 bits... or FFFFFFFF if you prefer hexadecimal). You could do a
comparison for the exact 429... number, but it is easier to just check for
a number greater than something around 65,000 (which I believe is December
16, 2077).

John M.

Yes and No.....I do want to show if a baseline had been saved, but
there will also be cases where costs were not inlcuded in the baseline.
So I might use the stated example to add another indicator, however I
will still need an indicator to show 0 Baseline Cost.

Another question on this topic:
I had seen this on a previous post and was wondering if you (or
someone) can tell me what the 65000 part of the formula meant.

Thanks,
-Mike

 

[John M.]

Well, look at that... IIF(ProjDateValue("NA")=[Baseline Start],true,false)
works just fine.

John M.

Actually you can test for N/A using the projdateval function

To the best of my understanding, in project professional, the
[Baseline...] fields are varients that are either dates (when a baseline
has been saved) or are 'NA' when one has not been saved. Unfortunately,
you can't do a check for "NA". The value that the 'NA' has during a
comparison is 4,294,967,295 (which happens to be the largest decimal
value for 32 bits... or FFFFFFFF if you prefer hexadecimal). You could
do a comparison for the exact 429... number, but it is easier to just
check for a number greater than something around 65,000 (which I believe
is December 16, 2077).

John M.

Yes and No.....I do want to show if a baseline had been saved, but
there will also be cases where costs were not inlcuded in the baseline.
So I might use the stated example to add another indicator, however I
will still need an indicator to show 0 Baseline Cost.

Another question on this topic:
I had seen this on a previous post and was wondering if you (or
someone) can tell me what the 65000 part of the formula meant.

Thanks,
-Mike

 

[John M.]

Well, look at that... I guess if you prefer the straight-forward approach,
comparing ProjDateValue("NA") to [Baseline Start] works out just fine. Who
would have thunk it.

John M.

Actually you can test for N/A using the projdateval function

To the best of my understanding, in project professional, the
[Baseline...] fields are varients that are either dates (when a baseline
has been saved) or are 'NA' when one has not been saved. Unfortunately,
you can't do a check for "NA". The value that the 'NA' has during a
comparison is 4,294,967,295 (which happens to be the largest decimal
value for 32 bits... or FFFFFFFF if you prefer hexadecimal). You could
do a comparison for the exact 429... number, but it is easier to just
check for a number greater than something around 65,000 (which I believe
is December 16, 2077).

John M.

Yes and No.....I do want to show if a baseline had been saved, but
there will also be cases where costs were not inlcuded in the baseline.
So I might use the stated example to add another indicator, however I
will still need an indicator to show 0 Baseline Cost.

Another question on this topic:
I had seen this on a previous post and was wondering if you (or
someone) can tell me what the 65000 part of the formula meant.

Thanks,
-Mike