Progress value calculation
Summarize
Summary of Progress Value Calculation
The progress value of goals in ServiceNow is automatically calculated based on specified formulas, depending on the structure of the goal (targets, sub-goals) and whether weighted averages are used. Understanding these calculations is essential for effectively tracking goal completion and performance within the platform.
Show less
Key Features
- Goals with Targets Only: If a goal has targets and no sub-goals, the progress value is computed as the sum of the progress values of the targets divided by the number of targets.
- Goals with Sub-goals and Targets: For goals that include both sub-goals and targets, the calculation includes the progress values of both, divided by the total number of sub-goals and targets.
- Weighted Average Calculation: If the system property
sngf.weightedaverageenabledis set to Yes, the progress value considers the weight scale of each target or sub-goal, allowing for more nuanced calculations.
Key Outcomes
By utilizing these formulas, customers can accurately assess the progress of their goals, ensuring that contributions from individual targets and sub-goals are appropriately reflected. For example, if Goal G1 has two targets T1 and T2 with different impacts and current progress percentages, the overall progress for G1 can be calculated using their contributions based on their defined weights.
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 |
|---|---|
|
Progress value of the goal = Sum of progress values of its associated targets / number of targets |
|
Progress value of the goal = Sum of progress values of its sub-goals and associated targets / number of sub-goals and targets |
|
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) |
|
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) |
- 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%