---
title: Status calculation specifications and examples
description: Detailed specifications for status calculation across different target types, calculation formulas for targets with and without breakdowns, and worked examples demonstrating status assignment and rollup mechanics.
locale: en-US
canonical_url: https://www.servicenow.com/docs/r/australia/it-business-management/goal-framework/target-status-calculation-examples.html
release: australia
product: Goal Framework
classification: goal-framework
topic_type: concept
last_updated: "2026-10-09"
reading_time_minutes: 7
breadcrumb: [Explore, Goal Framework and Goal Framework for SPM, Strategic Portfolio Management]
---

# Status calculation specifications and examples

Detailed specifications for status calculation across different target types, calculation formulas for targets with and without breakdowns, and worked examples demonstrating status assignment and rollup mechanics.

## Status calculation for targets without breakdowns

For targets without period-based breakdowns, status is calculated once using the overall actual value against the Final target value:

```
Achievement % = ((Actuals to date − Start value) ÷ (Final target value − Start value)) × 100
Status = Green if Achievement % ≥ 90; Yellow if 75–89; Red if < 75
```

**Example:** Achieve $1,000,000 revenue by the year-end

-   Start value \(baseline\): $0
-   Final target value: $1,000,000
-   Actuals to date \(year-end\): $700,000
-   Achievement % = \(\($700,000 − $0\) ÷ \($1,000,000 − $0\)\) × 100 = 70%
-   **Status: Red** \(70% &lt; 75%\)

## Status calculation for targets with cumulative breakdowns

For cumulative targets with period-based breakdowns, each period's start value carries forward from the previous period's actual value. Status is calculated for each check-in period independently based on that period's start value and planned target. The achievement percentage is recalculated for each period as new data is reported, and the most recent period's status determines the target status.

```
Achievement % (for period) = ((Period actual value − Period start value) ÷ (Period planned target value − Period start value)) × 100
Status (for period) = Green if Achievement % ≥ 90; Yellow if 75–89; Red if < 75
```

**Example:** Annual revenue target with cumulative quarterly check-ins \(Planned target and Actual values shown are cumulative amounts\)

In this example, each quarter's achievement is measured from a start value of $0, comparing the cumulative actual revenue to the cumulative planned target. The "Start value" column shows $0 for Q1, then carries forward the previous quarter's cumulative actual for reference purposes \(Q2: $220K from Q1, Q3: $480K from Q2, Q4: $710K from Q3\), but the formula always uses cumulative amounts from the $0 baseline.

|Quarter|Start value|Planned target|Actual|Achievement %|Status|
|-------|-----------|--------------|------|-------------|------|
|Q1|$0|$250,000|$220,000|88%|Yellow|
|Q2|$220,000|$500,000|$480,000|96%|Green|
|Q3|$480,000|$750,000|$710,000|94.7%|Green|
|Q4|$710,000|$1,000,000|$968,000|96.8%|Green|

In this scenario, each quarter is evaluated cumulatively from a start value of $0. Achievement % is calculated by comparing cumulative actual revenue to cumulative planned target: Q1: $220K ÷ $250K = 88% \(Yellow\). Q2: $480K ÷ $500K = 96% \(Green\). Q3: $710K ÷ $750K = 94.7% \(Green\). Q4: $968K ÷ $1,000K = 96.8% \(Green\). The most recent period \(Q4\) determines the target status, which is Green. Overall, the target is progressing at 96.8% achievement against the $1,000,000 annual goal.

-   **How breakdown statuses roll up to the target status**

    The target's overall status is determined using latest-wins logic: the status of the most recent reported breakdown period becomes the target status. This ensures the target status always reflects the most current performance data.

    -   Q1 status: Yellow \(88%\)
    -   Q2 status: Green \(96%\)
    -   Q3 status: Green \(94.7%\)
    -   Q4 status: Green \(96.8%\) ← **Most recent**
    -   **Target status: Green** \(determined by Q4, the latest reported quarter\)
    The target displays Green status even though Q1 was Yellow, because Q4's Green status is the most current indicator of performance. If Q4's actual had fallen short and resulted in Yellow or Red, the target status would immediately reflect that latest assessment.


## Status calculation for targets with non-cumulative breakdowns

For non-cumulative targets with period-based breakdowns, each period is independent and does not carry forward the previous period's actual value. Status is calculated as a window aggregating all periods with actual values from the first period to the most recent period. The achievement percentage is recalculated each time a new period is reported.

```
Window = Sum of all Actuals (Q1 through most recent quarter) ÷ Sum of all Planned (Q1 through most recent quarter)
Achievement % = (Total actuals ÷ Total planned) × 100
Status = Green if Achievement % ≥ 90; Yellow if 75–89; Red if < 75
```

**Example:** Annual revenue target \($0 start, $1,000,000 final target\) with non-cumulative quarterly check-ins

|Quarter|Planned \(this Q\)|Actual \(this Q\)|Breakdown status|Total actual|Total planned|Target window %|
|-------|------------------|-----------------|----------------|------------|-------------|---------------|
|Q1|$250,000|$220,000|88% \(Yellow\)|$220,000|$250,000|88%|
|Q2|$250,000|$240,000|96% \(Green\)|$460,000|$500,000|92%|
|Q3|$250,000|$200,000|80% \(Yellow\)|$660,000|$750,000|88%|
|Q4|$250,000|$230,000|92% \(Green\)|$890,000|$1,000,000|89% \(Target status\)|

Although Q4's individual breakdown shows Green \(92%\), the target displays Yellow \(89%\) because the target's status reflects the overall cumulative performance across all four quarters. Individual breakdown statuses show period-by-period progress, while the target status shows how the team is tracking toward the full-year goal.

**Key differences from cumulative:** In cumulative, each quarter's start value is the previous quarter's actual \($220K → $480K → $710K\), and each quarter's status is calculated individually. In non-cumulative, each quarter's Planned and Actual are also independent \($250K planned each quarter\), and each quarter's status is calculated independently \(Q1 = 88% Yellow, Q2 = 96% Green, Q3 = 80% Yellow, Q4 = 92% Green\). However, the target's overall status is determined by the cumulative window across all quarters: \($220K + $240K + $200K + $230K\) ÷ \($250K + $250K + $250K + $250K\) = 89% Yellow. This means the target can show Yellow status even when the latest quarter \(Q4\) shows Green—the target reflects overall annual progress, not the most recent period alone.

-   **How breakdown statuses roll up to the target status**

    The target's overall status is determined by aggregating all periods into a cumulative window. The target status is NOT determined by the most recent breakdown; instead, it reflects the cumulative performance across all reported periods.

    -   Q1 status: Yellow \(88% independent\)
    -   Q2 status: Green \(96% independent\)
    -   Q3 status: Yellow \(80% independent\)
    -   Q4 status: Green \(92% independent\)
    -   **Target window:** \($220K + $240K + $200K + $230K\) ÷ \($250K + $250K + $250K + $250K\) = $890K ÷ $1,000K = 89%
    -   **Target status: Yellow** \(89% determined by cumulative window, not by latest breakdown\)

## Status rollup mechanics

Status automatically rolls up through three hierarchical layers:

-   **Layer 1 for cumulative targets: Breakdown → Target \(Latest-wins logic\)**

    When a target has multiple check-in periods, the status of the target is determined by the most recent period's status:

    -   If March check-in status is Red, target status = Red
    -   If February check-in status is Yellow and March is Green, target status = Green \(most recent wins\)
-   **Layer 1 for non-cumulative targets: Breakdown → Target \(Cumulative window aggregation\)**

    For non-cumulative targets with period-based breakdowns, the target's overall status is determined by aggregating all periods into a single cumulative window. The target status is determined by the cumulative performance across all reported breakdown periods.

    -   Q1 status: Yellow \(88% independent\) — Actual: $220K, Planned: $250K
    -   Q2 status: Green \(96% independent\) — Actual: $240K, Planned: $250K
    -   Q3 status: Yellow \(80% independent\) — Actual: $200K, Planned: $250K
    -   Q4 status: Green \(92% independent\) — Actual: $230K, Planned: $250K
    -   **Target window calculation:** Total Actuals \($220K + $240K + $200K + $230K = $890K\) ÷ Total Planned \($250K + $250K + $250K + $250K = $1,000K\) = 89%
    -   **Target status: Yellow** \(89% from cumulative window, even though Q4 is Green\)
    The key distinction: individual breakdowns may show Green \(Q4 at 92%\), but the target displays Yellow because the cumulative performance across all quarters \(89%\) determines the target status. This reflects overall annual progress, not just the most recent period.

-   **Layer 2: Target → Goal \(Worst-wins logic\)**

    When a goal has multiple targets, the goal status is determined by the lowest-performing target:

    -   Target 1 status = Green \(90%\)
    -   Target 2 status = Red \(60%\)
    -   **Goal status = Red** \(worst-wins\)
-   **Layer 3: Goal → Parent goal \(Worst-wins logic\)**

    Goals roll up to parent goals using worst-wins logic:

    -   Goal 1 \(Parent goal\) status = Yellow
    -   Goal 1.2 \(Child goal\) status = Red
    -   Target 1.2.1 status = Yellow
    As a result, the parent goal \(Goal 1\) status will be Red, since a single red status propagates to the parent goal.


## Status rollup example: Three-layer cascade

This example shows how status cascades through all three layers:

```
LAYER 1 — Check-ins roll up to Targets (Latest-wins):
  Q1 Revenue Target:
    Week 1: Green (92%)
    Week 2: Yellow (78%)
    Week 3: Green (91%)  ← Most recent; Target Status = Green

LAYER 2 — Targets roll up to Goals (Worst-wins):
  Annual Growth Goal:
    Q1 Revenue Target: Green (91%)
    Q1 Cost Target: Red (60%)
    ├─ Goal Status = Red (cost target drags down entire goal)

LAYER 3 — Goals roll up to Parent goals (Worst-wins):
  Strategic Goals:
    Growth Goal: Red (from Annual Growth Goal)
    Efficiency Goal: Green (80%)
    Innovation Goal: Yellow (78%)
    ├─ Parent goal Status = Red (single red target/child goal cascades to parent goal)
```

## Special status calculation cases

-   **Manual override then recalculation**

    If you manually override status to Red, the override applies immediately. However, if you later update the actual value such that the achievement percentage would calculate as Green \(95%\), the system recalculates and displays Green. Manual overrides do not persist through data updates.

-   **Milestone targets \(qualitative goals\)**

    Milestone targets use a binary Yes/No status assignment instead of numeric formulas. You determine whether the milestone has been achieved: Yes = Green status, No = Red status. Yellow is not available. Examples: project readiness gates, regulatory approvals, capability certifications. Though not automatically calculated, milestone targets roll up from the target to its goal, and from the goal to parent goals if any, using worst-wins logic.