### How to troubleshoot a Calculation Field that is showing an incorrect Roll-Up Calculation

If you're having issues with a Calculation Field showing the incorrect calculation or not showing a calculation at all, check the following items to troubleshoot:

**Calculation Expression**

Check to make sure that your calculation formula is correct. Refer to the Creating Advanced Calculations or Cross-Workflow Calculations article to learn more about calculation formulas.

**Field Inputs**

Field inputs are what you're referencing with the **%f** place holders in the calculation expression. Check to see that you a referencing the right Fields that you want to include in your calculation.

**Blank Field Handling**

If you are not seeing a calculation appear in your Field, check whether you have 'N/A' selected under Blank Field Handling. This will prevent your calculation from working until all Fields have been filled out, including Fields in a conditional Section/Sub-section that wasn't triggered. If you do have Fields in conditional sections, then it is recommended to select either 'Use 0' or 'Use 1' as a default option.

**Actual Referenced Fields**

If you are referencing Select, Multi-select, Radio or Checkbox Fields, then double check each of the referenced Fields to make sure there is a correct numeric value associated with each of your selections. Often times this is the root cause for miscalculations since Calculation Fields pull in the numeric values. By default a Select Text Value is assigned 1 as a numeric value. If you want this value to be something different be sure to change this in all of your Select Text Values.

**Fields With Multiple Options Selected**

For Multi-select or Checkbox Fields, the calculation will refer to the *sum* of all values for each option selected. For example, a field has three options and corresponding values -- Option 1 [1], Option 2 [3], and Option 3 [5]. If Option 1 and Option 3 are selected for a record, the value [6] will be used as the referenced value for the calculation.

## Comments

0 comments

Please sign in to leave a comment.