Active Savings (Current Year) metric calculation

  • Release version: Australia
  • Updated March 31, 2025
  • 3 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 Active Savings (Current Year) metric calculation

    The Active Savings (Current Year) metric in ServiceNow represents the targeted savings from pipeline projects currently in progress, specifically those in the Work in Progress state. It captures projected savings for ongoing work where realized savings are not yet finalized. This metric uses theTargeted savingsfield and differs from Planned Savings by focusing only on projects that have started execution.

    Show full answer Show less

    Key Features

    • Metric scope: Projects in the Work in Progress state during a user-specified date range, typically the current calendar year.
    • Calculation basis: Reads from the Targeted savings field to reflect goal savings rather than final savings.
    • Date handling: The date range is divided into monthly intervals for detailed proration.
    • Proration: Savings are prorated monthly based on the overlap of project savings periods with each month, using a per-day savings rate capped at 365 days.
    • Usage: Data feeds the Savings by Type chart on the analytics dashboard for visibility into in-flight savings.

    How Active Savings Are Calculated

    1. The system receives a date range and active filters, typically the current calendar year.
    2. The range is split into monthly windows.
    3. For each month, projects are identified if they are in Work in Progress state, have savings start and end dates overlapping the month, and have non-zero Targeted savings.
    4. Proration formula applies:
      Prorated Savings = (Targeted Savings ÷ min(Project Days, 365)) × Overlap Days, where Project Days is capped at 365 for calculation.
    5. Monthly prorated savings are summed and aggregated into a time series for dashboard reporting.

    Practical Example

    Three pipeline projects illustrate the calculation for the calendar year 2024:

    • PIPE-301: 184-day project fully within 2024, prorated savings equal full targeted savings of $240,000.
    • PIPE-302: Full year project aligned with 2024, prorated savings equal $365,000.
    • PIPE-303: Multi-year project exceeding 365 days, capped at 365 days for proration, prorated savings equal $1,000,000.

    The total Active Savings (Current Year) aggregates to $1,605,000 for these projects.

    What This Enables for ServiceNow Customers

    This metric provides a clear, time-phased view of projected savings from ongoing projects, enabling customers to track and analyze pipeline savings performance throughout the year. By focusing on Work in Progress projects and applying consistent proration, customers gain accurate insights into their current-year savings potential, supporting better financial forecasting and decision-making.

    Active Savings (Current Year) shows the targeted savings from pipeline projects that are currently in progress. This metric represents in-flight work where final realized savings are not yet known.

    Active Savings (Current Year) reads from the Targeted savings field because work is still underway and the final realized savings are not yet known. The difference from Planned Savings is the pipeline state; Active Savings (Current Year) includes projects only in Work in Progress state.
    Note:
    Both Active Savings and Planned Savings read from the Targeted savings field. This is intentional — both represent projected or goal savings. The distinction is whether work on the project has started.

    Metric definition

    The following attributes define the Active Savings (Current Year) metric:

    Attribute Detail
    Metric name Active Savings (Current Year)
    Pipeline state Work in Progress
    Savings field Targeted savings
    Date range User-specified (typically the current calendar year)
    Proration Yes — overlap-based proration
    Used in Savings by Type chart on the analytics dashboard

    How Active Savings are calculated

    The calculation follows the same steps as Planned Savings, with the state filter set to Work in Progress instead of Planned.

    • Receive the date range. The dashboard passes a date range — typically the current calendar year — along with any active filters.
    • Break the range into monthly intervals. The system splits the full date range into individual month windows.
    • For each month, identify qualifying projects. The system queries the pipeline project table for projects in Work in Progress state where:
      • The project has a savings start date and a savings end date.
      • The savings period overlaps with the month window.
      • The project has a non-zero Targeted savings value.
    • Prorate each project's savings against the month window. The system applies the same proration formula used across all four metrics:
      • Per-day rate = Targeted savings ÷ project duration (capped at 365 days)
      • Prorated savings = per-day rate × overlap days
    • Sum the monthly totals. The prorated savings for all qualifying projects in each month are added together.
    • Aggregate across months. The monthly totals are combined into a time-series dataset for the Savings by Type chart on the analytics dashboard.

    Proration formula

    Prorated Savings = (Targeted Savings ÷ min(Project Days, 365)) × Overlap Days.

    Applied per month window, for Work in Progress projects only.

    Example calculation

    The following scenario demonstrates how Active Savings is calculated for three active pipeline projects during the date range of January 1 to December 31, 2024:

    Pipeline State Targeted Savings Savings Start Savings End Project Days
    PIPE-301 (Ongoing Vendor Negotiation) Work in Progress $240,000 Mar 1, 2024 Aug 31, 2024 184
    PIPE-302 (Fleet Cost Reduction) Work in Progress $365,000 Jan 1, 2024 Dec 31, 2024 365
    PIPE-303 (Strategic Sourcing) Work in Progress $1,000,000 Jun 1, 2023 May 31, 2025 730
    PIPE-301: Mid-year short project
    • Project duration = 184 days
    • Overlap with range = 184 days (project falls entirely within the year)
    • Per-day rate = $240,000 ÷ 184 = $1,304.35/day
    • Prorated savings = $1,304.35 × 184 = $240,000.00
    PIPE-302: Full year alignment
    • Project duration = 365 days
    • Overlap with range = 365 days (perfect alignment)
    • Per-day rate = $365,000 ÷ 365 = $1,000.00/day
    • Prorated savings = $1,000.00 × 365 = $365,000.00
    PIPE-303: Multi-year project (365-day cap applies)
    • Project duration = 730 days (Jun 2023 – May 2025) — exceeds 365 days
    • Overlap with range = 365 days (full year 2024)
    • Per-day rate = $1,000,000 ÷ 365 (capped) = $2,739.73/day
    • Prorated savings = $2,739.73 × 365 = $1,000,000.00

    Final aggregation

    The final aggregation sums the prorated values:

    Pipeline Prorated Active Savings
    PIPE-301 $240,000.00
    PIPE-302 $365,000.00
    PIPE-303 $1,000,000.00
    Total Active Savings (Current Year) $1,605,000.00