Treat Missing Values as Zero in Grid Formulas

A new grid property, Treat Missing as 0 in Formula, is now available in Reports. When enabled, any missing value (#missing) in the corresponding data cell is treated as zero during formula evaluation.

Previously, formulas that referenced #missing values resulted in a #error condition. With this new property, you can optionally treat missing values as zero, allowing formulas to evaluate successfully without errors.

Applies to: Profitability and Cost Management, Close Management and Consolidation, FreeForm, Narrative Reporting, Planning and Budgeting, Tax Reporting

Business Benefit: This enhancement helps in calculations when data is missing or incomplete, reducing errors, and eliminating the need for manual workarounds.

Key resources