1. Implementing Project Financial Management and Grants Management
  2. Examples of Performance Measure Formulas

Examples of Performance Measure Formulas

Suppose that you want to define a formula for original budget labor effort in days with 8 labor hours per business day.

Select Original budget [PT1_OP] as the Scenario Member and Labor effort [LABOR_HRS] as the Account Member and define the formula as follows:

([PT1_OP],[LABOR_HRS]) / 8

Suppose that you want to define a formula for original budget labor effort at completion in days versus current approved forecast labor effort in days with 8 labor hours per business day. Select the Use Time Dimension Member in Formula check box and define the formula as follows:

( ([PT1_OP],[LABOR_HRS],[AC]) / 8 ) - ( ([PT2_C],[LABOR_HRS],[AC]) / 8 )

  • To define the formula for original budget labor effort at completion in days, select Original budget [PT1_OP] as the Scenario Member, Labor effort [LABOR_HRS] as the Account Member, and Estimate at completion [AC] as the Time Member.

  • To define the formula for current approved forecast labor effort in days, select Current forecast [PT2_C] as the Scenario Member, Labor effort [LABOR_HRS] as the Account Member, and Estimate at completion [AC] as the Time Member.

Suppose that you want to define a formula for ITD Baseline Margin Percentage versus EAC Forecast Margin Percentage Variance. Select the Use Time Dimension Member in Formula check box and define the formula as follows:

(((([PT1_C],[REVENUE],[ITD]) - ([PT1_C],[BRDN_COST],[ITD])) / ([PT1_C],[REVENUE],[ITD])) * 100) - ((((([PT2_C],[REVENUE],[AC]) - ([PT2_C],[BRDN_COST],[AC])) / ([PT2_C],[REVENUE],[AC]))) * 100)