Using the Formula Builder
How to create formulas to perform calculations using your existing Scorecard's Measurables.
-
Account Options and Troubleshooting
-
Integrations and Beta
-
Using Ninety with EOS
-
Insights
-
Scorecard
-
Rocks
-
To-Dos
-
Issues
-
Meetings
-
Headlines
-
V/TO
-
Accountability Chart
-
1-on-1
-
People and Toolbox
-
Directory
-
Knowledge Portal
-
Assessments
-
Mobile
Table of Contents
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.
- Click
Scorecard from the left navigation.
- Click New Measurable on the intended Measurable group.
- Click Create new Measurable.
- Name the Measurable “Gross Profit.”
- Toggle on Formula Builder.
- Click Add Measurable.
- Search for and click your existing “Sales” Measurable.
- Select the subtract operator.
- Click Add Measurable.
- Search for and click your “Cost of Goods Sold” Measurable.
- Create a Goal (a specific number, range, etc.).
- Assign the Measurable's Owner.
- 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.
- Click
Scorecard from the left navigation.
- Click New Measurable on the intended Measurable group.
- Click Create new Measurable.
- Name the Measurable “Daily Average.”
- Toggle on Formula Builder.
- Click Add Measurable.
- Search for and click your existing “Weekly Sales” Measurable.
- Click the division operator.
- Click Add Number.
- Enter the number seven (7) and click the checkmark.
- Create a Goal.
- Assign the Measurable's Owner.
- 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.