Progress value calculation

  • Release version: Yokohama
  • Updated January 30, 2025
  • 2 minutes to read
    • Summarize
    Summarized using AI
    This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.

    Summary of Progress Value Calculation

    The progress value of goals in ServiceNow is automatically calculated based on specific formulas that depend on the presence of targets, sub-goals, and whether weighted averages are used. Understanding these calculations helps customers effectively track goal completion and performance metrics.

    Show full answer Show less

    Key Features

    • Goals with Targets: If a goal has only targets, the progress is calculated as the sum of the progress values of its targets divided by the number of targets.
    • Goals with Sub-goals and Targets: For goals with both sub-goals and targets, the progress value is determined by the sum of the progress values of sub-goals and targets divided by their total count.
    • Weighted Average Calculation: When the weighted average is enabled, the formula incorporates the weight scales of each target or sub-goal. This allows for a more nuanced calculation based on their contributions to the overall goal.

    Key Outcomes

    Understanding how the progress value is calculated enables ServiceNow customers to monitor the effectiveness of their goals accurately. For example, if a goal has two targets with defined impacts, the contributions are calculated proportionally based on their weights and progress values, providing a clear picture of overall goal achievement.

    The progress or percentage complete value of goals is auto-calculated using different formulas. The formula depends on whether the goal has only targets, a combination of sub-goals and targets, and if it has weighted average calculation enabled.

    Scenario Formula used to calculate the progress value of the goal
    • The goal has targets.
    • The goal doesn’t have sub-goals.
    • The Impact on goal field is defined for targets.
    		 Progress value of the goal = Sum of progress values of its associated targets / number of targets
    • The goal has sub-goals and targets.
    • The Impact on parent goal and Impact on goal fields are defined for sub-goals and targets respectively.
    		 Progress value of the goal = Sum of progress values of its sub-goals and associated targets / number of sub-goals and targets
    • The goal has two targets (target 1 and target 2).
    • The goal doesn’t have sub-goals.
    • The Impact on goal field is defined for targets and the sn_gf.weighted_average_enabled system property is set to Yes.
    		 Progress value of the goal = [(Progress of target 1 * Weight scale of target 1) + (Progress of target 2 * Weight scale of target 2)] / (Weight scale of target 1 + Weight scale of target 2)
    • The goal has two targets (target 1 and target 2).
    • The goal has two sub-goals (sub-goal 1 and sub-goal 2).
    • The Impact on parent goal and Impact on goal fields are defined for sub-goals and targets respectively and the sn_gf.weighted_average_enabled system property is set to Yes.
    		 Progress value of the goal = [(Progress of sub-goal 1 * Weight scale of sub-goal 1) + (Progress of sub-goal 2 * Weight scale of sub-goal 2) + (Progress of target 1 * Weight scale of target 1) + (Progress of target 2 * Weight scale of target 2)] / (Weight scale of sub-goal 1 + Weight scale of sub-goal 2 + Weight scale of target 1 + Weight scale of target 2)
    Consider a scenario where a goal (G1) has two targets (T1 and T2) and the Impact on goal field for T1 and T2 is set to 2 and 3 respectively. The current Progress values of T1 and T2 are 40% and 20% respectively. In this case, the progress value for G1 is calculated as follows:
    • Contribution of T1 towards G1 progress = 2/(2+3)*40 = 16%
    • Contribution of T2 towards G1 progress = 3/(2+3)*20 = 12%
    • Therefore, Progress of G1 = 16% +12% = 28%