How to Use Calculations in Goals #
Calculations allow you to create a goal that is built from one or more existing goals. This is useful for combining metrics, such as rolling up individual performance into a total.
What Are Calculated Goals? #
A calculated goal uses data from other goals to generate a new metric.
Example:
- Individual goals: Jocelyn’s Revenue + Tiffany’s Revenue
- Calculated goal: Total Revenue
Step 1: Start a New Goal #
- Navigate to the Goals module
- Click Add Goal
Step 2: Define Basic Goal Details #
- Goal Name (e.g., Total Revenue)
- Year
- Calculation Type (typically Sum for rollups)
Step 3: Select Calculation as the Source #
Under Source:
- Choose Calculation
- Select Formula Builder
Step 4: Build Your Formula #
- Select the first goal to include
- Example: Jocelyn’s Revenue
- Choose an operator
- Example: + (Add)
- Select the second goal
- Example: Tiffany’s Revenue
Your formula will look like:
- Jocelyn’s Revenue + Tiffany’s Revenue
You can continue adding additional goals if needed.
Step 5: Assign Ownership and Access #
- Owner (defaults to you)
- Editors (can update the goal)
- Viewers (read-only access)
Step 6: Save the Goal #
- Click Submit
- The calculated goal will appear on your Goals dashboard
Identifying Calculated Goals #
- Calculated goals display a calculation icon
- Hovering over the icon shows:
- The formula used
- The goals included in the calculation
Key Takeaways #
- Calculations allow you to combine multiple goals into one metric
- They are ideal for rollups (team totals, department totals, etc.)
- The formula builder makes it easy to create and adjust calculations
- You can always view the underlying formula for transparency