Calculated Fields
Calculated fields let you do math on other field values and display the result directly in the form. Use them to show order totals, compute scores, or derive any value from the respondent's answers in real time.
Creating a Calculated Field
- Add a Calculated field from the Advanced category in the field sidebar.
- In the field settings panel, find the Formula section.
- Build the formula by adding operands and choosing an operator between them.
- Set a prefix, suffix, and the number of decimal places for the result.
The calculated field updates its value in real time as the respondent fills in the referenced fields. The result is read-only and cannot be edited by the respondent.
Building the Formula
You do not type a text formula. Instead, you assemble it from a list of operands using the builder UI in the field settings panel.
- Add an operand. Each operand is either a field (pick one of your form fields from a dropdown) or a fixed constant (type a number).
- Choose an operator (add, subtract, multiply, or divide) to combine it with the next operand.
- Add as many operands as you need to build the full calculation.
When an operand references a field, that field should be a numeric type (Number, Rating, Scale, or another Calculated field) or a choice field whose options carry numeric weights. Choice option weights are summed for multi-select fields. A field that has not been answered contributes 0, so hidden or skipped questions never break the result.
Math Operators
Each operand is combined with the next using one of four operators:
| Operator | What it does |
|---|---|
| Add | Adds the two operands together. |
| Subtract | Subtracts the next operand from the running result. |
| Multiply | Multiplies the two operands. |
| Divide | Divides the running result by the next operand. |
Multiply and divide are applied first (left to right), then add and subtract. Dividing by zero produces no value, so the field simply shows nothing until a valid number is entered.
Displaying Results
Three settings control how the computed value is shown to the respondent:
- Prefix: text placed before the number (for example a currency symbol like $).
- Suffix: text placed after the number (for example a unit like kg or a percent sign).
- Decimal places: how many digits to show after the decimal point (for example 2 for currency, 0 for whole numbers).
For instance, a prefix of $ with two decimal places displays a subtotal as $149.99, while a suffix of % with zero decimal places shows a score as 85%.
Common Calculations
Order Subtotal
Add a Quantity field and a Unit Price field, then build a calculated field with two operands: the Quantity field, multiplied by the Unit Price field. Set the prefix to $ and decimal places to 2.
Weighted Quiz Score
Give each answer option a numeric weight, then add the relevant fields as operands joined by the add operator. The calculated field sums the selected weights into a single score.
Average of Three Ratings
Add the three rating fields together, then add a fourth operand that is a constant of 3 and join it with the divide operator. The result is the average rating.
Tip: Calculated fields can reference other calculated fields. This lets you chain calculations (for example a subtotal feeds into a total). Build each step as its own calculated field and point the next one at it.