AnsweredAssumed Answered

Overall Status Calculation

Question asked by Art_Vendryes on May 15, 2018
Latest reply on May 16, 2018 by suhail-sayed

Up to now we have been using the standard Overall Status calculation based on Scope, Schedule and Effort dropdown selections (we don't look at cost).  We are now moving to two Overall Status indicators.  One will use the dropdown selections and the ask for the other is to use the dropdown selection for Scope, the system calculated Schedule Variance and the system calculate effort variance.  I created another calculated attribute and I have tried using various calculations, but keep getting invalid expression error. Has anyone combined something like these?  The two calculated attributes information is below:

 

System Schedule Var %

Referenced Item's Object Type Project

Referenced Attribute: Schedule to Baseline

Current Expression: DateDiff(baseline_finish,schedule_finish,"Day")

Color

Description

From

To

White

Default Bucket

 

 

Green

Ahead of Schedule

-100,000

0

Green

On Schedule

0

1

Yellow

Between 1 and 10 Days Late

1

11

Red

More than 10 Days Late

11

100,000

System Effort Var %

Referenced Item's Object Type: Project

Referenced Attribute: Projected Effort Variance %

Current Expression: ((ttl_effort-baseline_usage)/baseline_usage)*100

Color

Description

From

To

White

Default Bucket

 

 

Green

Less Than Baseline

-100,000

0

Green

No Variance to Baseline

0

1

Yellow

Between 1 and 10% Over Baseline

1

11

Red

More than 10% Over Baseline

11

100,000

 

 

Thanks in advance,

Art

Outcomes