---
title: Creating Calculated Data Values for a Measure
description: A calculated measure uses a mathematical formula to calculate values, based on data from other measures. 
---

[Skip to content](https://support.clearimpact.com/en/2023-creating-calculated-data-values-for-a-measure#main-content)

English

Show submenu for translations

[Contact Support](https://support.clearimpact.com/en/kb-tickets/new?hsLang=en)

[![Clear-Impact-Logo-Wide-Tagline-RGB.png\]](https://support.clearimpact.com/hs-fs/hubfs/images/Clear-Impact-Logo-Wide-Tagline-RGB.png?height=40&name=Clear-Impact-Logo-Wide-Tagline-RGB.png)](https://support.clearimpact.com/?hsLang=en)

Open main navigation

Close main navigation

- English
  
  Show submenu for translations
- [Contact Support](https://support.clearimpact.com/en/kb-tickets/new)
- [Help Desk](https://support.clearimpact.com/en/kb-tickets/new)

[Help Desk](https://support.clearimpact.com/en/kb-tickets/new?hsLang=en)

 Hi, how can we help you?

- There are no suggestions because the search field is empty.

1. [Help Center](https://support.clearimpact.com/en?hsLang=en)
2. [Scorecard Documentation](https://support.clearimpact.com/en/scorecard-documentation?hsLang=en)
3. [Entering Scorecard Data and Notes](https://support.clearimpact.com/en/scorecard-documentation?hsLang=en#entering-scorecard-data-and-notes)

# Creating Calculated Data Values for a Measure

As opposed to a measure whose [data is entered manually](https://support.clearimpact.com/en/2023-entering-data-values-and-target-values-for-a-measure?hsLang=en), a calculated measure uses a mathematical formula to calculate values, based on data from other measures. 

- A calculated measure, whose data comes from other measures, is called an **aggregated measure** (parent measure).
- A measure whose data is used for the calculations in a calculated measure is called a **disaggregated** measure (or child measure)

*Note: This article discusses how to create a calculated measure whose data comes from other measures. If your account includes [variables](https://support.clearimpact.com/en/2023-variables?hsLang=en), you can also create a [calculated measure whose data comes from one or more variables](https://support.clearimpact.com/en/2023-creating-calculated-data-values-using-variables?hsLang=en).*

*There is also a separate article on [editing disaggregated measure data](https://support.clearimpact.com/en/editing-calculated-data-values-for-a-measure?hsLang=en).*

In this example, the indicator “% of students who graduate high school on time,” will use calculated data. 

![](https://support.clearimpact.com/hs-fs/hubfs/Screenshot%202025-11-06%20at%203-13-31%E2%80%AFPM-png.png?width=531&height=254&name=Screenshot%202025-11-06%20at%203-13-31%E2%80%AFPM-png.png)

 

This calculation requires data from two disaggregated (child) measures: 

- Total number of high school seniors
- Total number of high school seniors who graduate on time.

The two disaggregated measures in this example are already created, and are not directly included in any scorecard container. (This is a common use case for [creating measures from scratch](https://support.clearimpact.com/en/2023-creating-a-measure-from-scratch?hsLang=en), not part of a container.)

![](https://support.clearimpact.com/hs-fs/hubfs/Screenshot%202025-11-06%20at%203-13-52%E2%80%AFPM-png.png?width=1066&height=436&name=Screenshot%202025-11-06%20at%203-13-52%E2%80%AFPM-png.png)

*Note: This example demonstrates how to create a parent measure when child measures are created in advance. While this is the more common way to create an aggregated measure, you can also work the opposite way: linking child measures to a parent measure already set up. *

 

**Important: Each child measure must have the same frequency as the calculated (parent) measure. Each child measure must also contain data.**

 

Both child indicators in this example use a [custom frequency](https://support.clearimpact.com/en/2023-reporting-frequencies?hsLang=en) called “Graduation,” an annual frequency with data recorded every June 25.

![](https://support.clearimpact.com/hs-fs/hubfs/Screenshot%202025-11-06%20at%203-14-17%E2%80%AFPM-png.png?width=459&height=365&name=Screenshot%202025-11-06%20at%203-14-17%E2%80%AFPM-png.png)

 

[Open the parent measure](https://support.clearimpact.com/en/2023-viewing-or-editing-a-measure?hsLang=en) that will use calculated data. In this example, the measure frequency does not match that of the two child measures. Also, by  default, measures are **Not Calculated.** Click the measure’s **Edit** button. 

![](https://support.clearimpact.com/hs-fs/hubfs/Screenshot%202025-11-06%20at%203-15-00%E2%80%AFPM-png.png?width=527&height=137&name=Screenshot%202025-11-06%20at%203-15-00%E2%80%AFPM-png.png)

 

Open **Data Properties** and set the correct frequency ("Graduation," in this example). **Calculation Type** for this example is **Ratio x 100** because the desired result is a percentage. If the calculated data is to be compared to target values, be sure to enable **Manual Targets**. Click **Save**.

![](https://support.clearimpact.com/hs-fs/hubfs/Screenshot%202025-11-06%20at%203-15-23%E2%80%AFPM-png.png?width=483&height=132&name=Screenshot%202025-11-06%20at%203-15-23%E2%80%AFPM-png.png)

 

*Note: The calculation types of* ***Sum****,* ***Average****, and* ***Ratio*** *are self-explanatory, and include data from all disaggregated measures added to the calculated measure. There are also several types of [accumulated calculations](https://support.clearimpact.com/en/2023-creating-accumulated-calculations?hsLang=en) that are performed on only one disaggregated measure.  *

*If you need to use a calculation other than the provided defaults, you can create a [custom calculation](https://support.clearimpact.com/en/2023-creating-custom-calculations?hsLang=en).*

The calculation type, and correct frequency, are now listed in the measure description. To define the first calculation data source (child measure), click **Add** **Existing Measure** in the **Relationships** section. (Or use the **Add Variable** button if your data source is a [variable](https://support.clearimpact.com/en/2023-variables?hsLang=en).)

![](https://support.clearimpact.com/hs-fs/hubfs/Screenshot%202025-11-06%20at%203-16-03%E2%80%AFPM-png.png?width=518&height=477&name=Screenshot%202025-11-06%20at%203-16-03%E2%80%AFPM-png.png)

 

In the **Add Measure(s) To** window, set the **Relationship** to **Disaggregated - Child**. This means the measures you’re about to add will provide the source data for the calculation. 

![](https://support.clearimpact.com/hs-fs/hubfs/Screenshot%202025-11-06%20at%203-18-03%E2%80%AFPM-png.png?width=449&height=283&name=Screenshot%202025-11-06%20at%203-18-03%E2%80%AFPM-png.png)

 

To find the child measures, you can filter by type, [tags](https://support.clearimpact.com/en/2023-tags?hsLang=en), or title. Click **Search** to see the results. Only measures that have the same frequency as the calculated measure will be available for selection. 

*Note: If you have access to [shared measures](https://support.clearimpact.com/en/2023-shared-containers-and-measures?hsLang=en) from other organizations, those measures can be used for calculations. Use the* ***Instance*** *drop-down at the top to look for measures from another instance.*

 

When selecting the child measures that will be used for the calculation, keep in mind that **for some calculations, selection order is important**. In this example, because the calculation is a ratio, the measure for graduates should be selected before the measure for total students. (Don’t worry -  if you get the order wrong, it can be easily fixed later.) Click **Add** to continue.

![](https://support.clearimpact.com/hs-fs/hubfs/Screenshot%202025-11-06%20at%203-18-35%E2%80%AFPM-png.png?width=427&height=381&name=Screenshot%202025-11-06%20at%203-18-35%E2%80%AFPM-png.png)

 

 The percent calculation in this example requires two measures, and two measures were added. This automatically executes the calculation. (If only one measure were added, calculations would not run until a second measure is added.)

After the system completes the calculations, the graph for the calculated measure is generated. If the data looks incorrect (as in this example where the percentages are greater than 100), or if you want to add target values, click **Edit / Data**. 

![](https://support.clearimpact.com/hs-fs/hubfs/Screenshot%202025-11-06%20at%203-19-15%E2%80%AFPM-png.png?width=448&height=423&name=Screenshot%202025-11-06%20at%203-19-15%E2%80%AFPM-png.png)

 

The child measures are listed in the **Data** section, and you can drag a measure’s three-dot icon to rearrange order if needed. You can also add target values here, if enabled for the measure. Click **Save** when finished.

![](https://support.clearimpact.com/hs-fs/hubfs/Screenshot%202025-11-06%20at%203-19-56%E2%80%AFPM-png.png?width=439&height=373&name=Screenshot%202025-11-06%20at%203-19-56%E2%80%AFPM-png.png)

*Note: When actual values are calculated, they cannot be overwritten manually.*

 

After saving, the calculations in this example are now correct, and are plotted against their targets. 

![](https://support.clearimpact.com/hs-fs/hubfs/Screenshot%202025-11-06%20at%203-20-32%E2%80%AFPM-png.png?width=464&height=442&name=Screenshot%202025-11-06%20at%203-20-32%E2%80%AFPM-png.png)

 

In the **Relationships** section of the calculated measure, the child measures appear under **Disaggregated Measures that are used to Calculate this Measure**. Child measure order can be rearranged here as well, though you would have to edit the data again and save, in order to recalculate.

![](https://support.clearimpact.com/hs-fs/hubfs/Screenshot%202025-11-06%20at%203-20-59%E2%80%AFPM-png.png?width=468&height=420&name=Screenshot%202025-11-06%20at%203-20-59%E2%80%AFPM-png.png)

*Note: There are several ways to [edit a calculated measure's disaggregated data](https://support.clearimpact.com/en/editing-calculated-data-values-for-a-measure?hsLang=en).*

 

To start over with new child measures, click **Remove All / Disaggregated Measures**, then confirm.

![](https://support.clearimpact.com/hs-fs/hubfs/Screenshot%202025-11-06%20at%203-21-35%E2%80%AFPM-png.png?width=468&height=416&name=Screenshot%202025-11-06%20at%203-21-35%E2%80%AFPM-png.png)

 

When a disaggregated measure is open, its **Relationship** section shows the calculated measure that uses it, listed under **Measures that Aggregate this Measure**.

![](https://support.clearimpact.com/hs-fs/hubfs/Screenshot%202025-11-06%20at%203-22-04%E2%80%AFPM-png.png?width=471&height=312&name=Screenshot%202025-11-06%20at%203-22-04%E2%80%AFPM-png.png)

*Note: Many users create nested calculations. For example:*

- *“Calculated Measure 1 ” tracks the sum of high school seniors from multiple schools.*
- *“Calculated Measure 2” produces the sum of on-time graduates from those schools.*
- *“Calculated Measure 3” is the percent of all on-time graduates, based on data from Calculated Measures 1 and 2.*

*The advantage of nested calculations is that data editing need only be done to the original source measures.*

 

Finally, in the [scorecard view](https://support.clearimpact.com/en/2023-viewing-a-scorecard?hsLang=en), calculated measures are indicated by a green dot. If data is missing and so that the values cannot be calculated, this dot will be red.

![](https://support.clearimpact.com/hs-fs/hubfs/Screenshot%202025-11-06%20at%203-22-29%E2%80%AFPM-png.png?width=539&height=242&name=Screenshot%202025-11-06%20at%203-22-29%E2%80%AFPM-png.png)

If needed, you can run all calculations at once, by clicking **Options** along the top and choosing **Initiate Calculations**.

![](https://support.clearimpact.com/hs-fs/hubfs/Screenshot%202025-11-06%20at%203-22-53%E2%80%AFPM-png.png?width=585&height=239&name=Screenshot%202025-11-06%20at%203-22-53%E2%80%AFPM-png.png)

*Note: For admins, a record of all calculation initiations can be found in the [**Measure Values Update Log**](https://support.clearimpact.com/en/scorecard-calculations-log?hsLang=en).*

 

- [Scorecard Documentation](https://support.clearimpact.com/en/scorecard-documentation?hsLang=en#main-content)

    - [Getting Started](https://support.clearimpact.com/en/scorecard-documentation?hsLang=en#getting-started)
    - [Scorecards](https://support.clearimpact.com/en/scorecard-documentation?hsLang=en#scorecards)
    - [Scorecard Objects](https://support.clearimpact.com/en/scorecard-documentation?hsLang=en#scorecard-objects)
    - [Entering Scorecard Data and Notes](https://support.clearimpact.com/en/scorecard-documentation?hsLang=en#entering-scorecard-data-and-notes)
    - [Viewing or Editing Scorecard Objects and Data](https://support.clearimpact.com/en/scorecard-documentation?hsLang=en#viewing-or-editing-scorecard-objects-and-data)
    - [Actions](https://support.clearimpact.com/en/scorecard-documentation?hsLang=en#actions)
    - [Reports](https://support.clearimpact.com/en/scorecard-documentation?hsLang=en#reports)
    - [Tools](https://support.clearimpact.com/en/scorecard-documentation?hsLang=en#tools)
    - [Site-Level Settings](https://support.clearimpact.com/en/scorecard-documentation?hsLang=en#site-level-settings)
    - [API](https://support.clearimpact.com/en/scorecard-documentation?hsLang=en#api)
    - [Upgrade Notes](https://support.clearimpact.com/en/scorecard-documentation?hsLang=en#upgrade-notes)
    - [FAQ (Scorecard)](https://support.clearimpact.com/en/scorecard-documentation?hsLang=en#faq-scorecard)
- [Scorecard Video Tutorials](https://support.clearimpact.com/en/scorecard-video-tutorials?hsLang=en#main-content)

    - [Upgrade Videos](https://support.clearimpact.com/en/scorecard-video-tutorials?hsLang=en#upgrade-videos)
    - [Training Videos](https://support.clearimpact.com/en/scorecard-video-tutorials?hsLang=en#training-videos)
    - [Customer Success Stories](https://support.clearimpact.com/en/scorecard-video-tutorials?hsLang=en#customer-success-stories)
- [Compyle Documentation](https://support.clearimpact.com/en/compyle-documentation?hsLang=en#main-content)

    - [Compyle Overview](https://support.clearimpact.com/en/compyle-documentation?hsLang=en#compyle-overview)
    - [Participants, Households, and Organizations](https://support.clearimpact.com/en/compyle-documentation?hsLang=en#participants-households-and-organizations)
    - [Data Collection](https://support.clearimpact.com/en/compyle-documentation?hsLang=en#data-collection)
    - [Analytics](https://support.clearimpact.com/en/compyle-documentation?hsLang=en#analytics)
    - [Administration](https://support.clearimpact.com/en/compyle-documentation?hsLang=en#administration)
    - [Administration - Forms and Fields](https://support.clearimpact.com/en/compyle-documentation?hsLang=en#administration-forms-and-fields)
    - [Scorecard Feeds](https://support.clearimpact.com/en/compyle-documentation?hsLang=en#scorecard-feeds)
    - [Compyle Release Notes](https://support.clearimpact.com/en/compyle-documentation?hsLang=en#compyle-release-notes)
    - [FAQ (Compyle)](https://support.clearimpact.com/en/compyle-documentation?hsLang=en#faq-compyle)
    - [Referral Network (Compyle-to-Compyle Referrals)](https://support.clearimpact.com/en/compyle-documentation?hsLang=en#referral-network-compyle-to-compyle-referrals)
- [Compyle Video Tutorials](https://support.clearimpact.com/en/compyle-video-tutorials?hsLang=en#main-content)

    - [Compyle Overview Videos](https://support.clearimpact.com/en/compyle-video-tutorials?hsLang=en#compyle-overview-videos)
    - [Upgrade Webinars](https://support.clearimpact.com/en/compyle-video-tutorials?hsLang=en#upgrade-webinars)
- [Control Documentation](https://support.clearimpact.com/en/control-documentation?hsLang=en#main-content)

    - [Control Overview](https://support.clearimpact.com/en/control-documentation?hsLang=en#control-overview)
    - [Control for Users](https://support.clearimpact.com/en/control-documentation?hsLang=en#control-for-users)
    - [Control for Administrators](https://support.clearimpact.com/en/control-documentation?hsLang=en#control-for-administrators)
    - [Control FAQ](https://support.clearimpact.com/en/control-documentation?hsLang=en#control-faq)
    - [Clear Impact Suite Overview](https://support.clearimpact.com/en/control-documentation?hsLang=en#clear-impact-suite-overview)
    - [Suite Release Notes](https://support.clearimpact.com/en/control-documentation?hsLang=en#suite-release-notes)
- [Showcase Documentation](https://support.clearimpact.com/en/showcase-documentation?hsLang=en)
- [Unlimited Suite Documentation](https://support.clearimpact.com/en/unlimited-suite-documentation?hsLang=en#main-content)

    - [Suite Implementation Materials](https://support.clearimpact.com/en/unlimited-suite-documentation?hsLang=en#suite-implementation-materials)
    - [Managing Partner/Child Sites](https://support.clearimpact.com/en/unlimited-suite-documentation?hsLang=en#managing-partner-child-sites)
    - [Rolling Up Data Across the Unlimited Suite Network](https://support.clearimpact.com/en/unlimited-suite-documentation?hsLang=en#rolling-up-data-across-the-unlimited-suite-network)
- [Clear Impact Live Training](https://support.clearimpact.com/en/clear-impact-live-training?hsLang=en#main-content)

    - [Free and Customized Training](https://support.clearimpact.com/en/clear-impact-live-training?hsLang=en#free-and-customized-training)
    - [Software Courses](https://support.clearimpact.com/en/clear-impact-live-training?hsLang=en#software-courses)
- [Collaborate with Clear Impact](https://support.clearimpact.com/en/collaborate-with-clear-impact?hsLang=en#main-content)

    - [Coming Attractions & Sneak Peeks](https://support.clearimpact.com/en/collaborate-with-clear-impact?hsLang=en#coming-attractions-sneak-peeks)
    - [Resources & Results](https://support.clearimpact.com/en/collaborate-with-clear-impact?hsLang=en#resources-results)

[![Logo\_ClearImpact\_White](https://support.clearimpact.com/hs-fs/hubfs/Logo_ClearImpact_White.png?width=341&height=80&name=Logo_ClearImpact_White.png "Logo_ClearImpact_White")](http://www.clearimpact.com)

Clear Impact Help Center | support@clearimpact.com

<https://www.linkedin.com/company/clear-impact-llc/posts/?feedView=all> <https://clearimpact.com/resources/turning-curves-podcast/> <https://clearimpact.com/social-sector-hero/>

Copyright © 2025, Clear Impact, Inc. LLC.