Using the Formula Builder

How to create formulas to perform calculations using your existing Scorecard's Measurables.

Written by Tommy Mains

Updated at May 1st, 2025

The Formula Builder allows users to create mathematical formulas to generate a Measurable's score. The calculations can include existing Measurables as variables. With the Formula Builder, you can use the following basic mathematical operators, including order of operations formulas with parentheses:

  • Addition
  • Subtraction
  • Multiplication
  • Division

 

To create a new Measurable with the Formula Builder or create a formula for an existing Measurable, click the Enable Formula Builder toggle at the bottom of the Measurable's details card.

Note: The Formula Builder was previously called Smart Measurable.

 

How to Use the Formula Builder

Click through the tabs below to learn about the Formula Builders features.

Adding Measurables as Variables

The Formula Builder allows you to utilize your Measurables as variables in a mathematical expression.

Example: You are already capturing “Sales” and “Cost of Goods Sold” on your Scorecard and want to generate “Gross Profit” automatically. The following directions follow this example.

  1. Click Scorecard from the left navigation.
  2. Click New Measurable on the intended Measurable group.
  3. Click Create new Measurable.
  4. Name the Measurable “Gross Profit.”
  5. Toggle on Formula Builder.
  6. Click Add Measurable.
  7. Search for and click your existing “Sales” Measurable.
  8. Select the subtract operator.
  9. Click Add Measurable.
  10. Search for and click your “Cost of Goods Sold” Measurable.
  11. Create a Goal (a specific number, range, etc.).
  12. Assign the Measurable's Owner.
  13. Click Save.
 
 

Adding Constant Variables

Constants allow you to treat numbers the same for each calculation.

Example: You want to calculate a “daily average” by dividing your Weekly Measurable by seven.

  1. Click Scorecard from the left navigation.
  2. Click New Measurable on the intended Measurable group.
  3. Click Create new Measurable.
  4. Name the Measurable “Daily Average.”
  5. Toggle on Formula Builder.
  6. Click Add Measurable.
  7. Search for and click your existing “Weekly Sales” Measurable.
  8. Click the division operator.
  9. Click Add Number.
  10. Enter the number seven (7) and click the checkmark.
  11. Create a Goal.
  12. Assign the Measurable's Owner.
  13. Click Save.
 
 

Clearing Formulas

There are two options for deleting aspects of your Measurable's formula.

  • Click the Backspace button () in the window to remove one element at a time, starting from the end of the formula.
  • Click the X (Clear All) button to empty the formula field.
 
 

 

Permissions Needed

Only users with the role of Manager and above can add or edit Measurables.

 

 

Frequently Asked Questions (FAQs)

Do the Measurables used as variables need to be on the same Scorecard as the Measurable using the Formula Builder?

No, Measurables used as variables do not need to be on the same Scorecard as the Measurable using the Formula Builder. As long as those Measurables are maintained to stay up-to-date somewhere in Ninety (other than the archive), the Measurable using the Formula Builder can access their data. 

 
 

What happens if the Measurables used as variables are missing data?

If the Measurables used as variables are missing data or are otherwise not maintained, the individual cells affected will display an “Invalid” error.