What does the calculation error mean in a budget or forecasting table?

The calculation (#CALC!) error in calculated columns of a budget or forecasting view indicates a formula calculation issue. This error state appears when standard mathematical rules are violated during a column calculation.

Hover over the error to view a tooltip detailing the underlying issue:

• A summation error. An error occurred while summing or aggregating the referenced fields.

• No value. A referenced cell or required variable contains missing or null data.

• Divide by zero. The formula attempts to divide a number by a cell or variable that equals $0 or is blank.

• Check Referenced Values: Review the source columns used in the calculated column to ensure all required fields contain valid numeric entries.

• Update the Formula: Edit the custom column configuration to handle zero or null values. For example, ensure that denominators in percentage calculations cannot evaluate to zero.