Variance Range Filter

[Robert]

If seems like it should be extremely simple, but it eludes me!

I want to display tasks where the schedule variance is +/- 5%

When I create a filter on SV%, to be less than 5%, everything is OK. When I
add 'AND "Greater Than or Equal To" -5%, Project returns "Invalid Entry."

What am I missing? What is the correct syntax?

Thanks in advance.

Robert

 

[DavidC]

Hi,

Try "or". You seem to be asking for a condition where the variance value in
the field is both +5% AND -5% on each activity. What it sounds like you need
is for the response to be valid if for an activity the variance is >+5%, OR
if the variance is <-5%.

Hope this helps

DavidC

 

[Robert]

Hi Dave, Thanks for your input. Th e OR doesn't work. What I am rying to
do is expand the definition of "On Schedule" from zero SV% to 0% +/- 5%. The
problem happens when I enter any number in the Value column which includes a
"-". Any other suggestions?

thanks

 

[DavidC]

Hi,
I don't use project for cost, but here goes with a suggestion. As you sayt
the filter does not like looking for negative values, so why not create a
custom field (try text) and set that to equal the values in SV%, then do the
filter on that field. Using the text field will allow it to recognise the
negative values.

Regards

DavidC