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: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Narrative Reporting, Planning, 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