Progress value calculation

  • Release version: Xanadu
  • Updated August 1, 2024
  • 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 calculation for goals in ServiceNow is automatically determined using specific formulas based on the structure of the goal, which may include targets and sub-goals. Understanding these formulas is crucial for accurately tracking the completion status of your goals.

    Show full answer Show less

    Key Features

    • Goals with Targets: For goals with only targets, the progress is calculated by summing the progress of each target and dividing by the number of targets.
    • Goals with Sub-goals and Targets: If a goal has both sub-goals and targets, the progress is calculated by summing the progress of sub-goals and targets, then dividing by their total count.
    • Weighted Average Calculation: When weighted averages are enabled, the progress value takes into account the weight scale of each target or sub-goal, allowing for a more nuanced calculation based on their relative importance.

    Key Outcomes

    By accurately applying these formulas, you can effectively track the progress of your goals. For example, if a goal has defined impacts and associated progress values, such as in the scenario with targets T1 and T2, you can see how each component contributes to the overall goal progress. This ensures a precise evaluation of goal completion, enabling better decision-making and resource allocation.

    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%