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)