Validate Formulas

Formula Validation finds formula errors per version and provides links and details to help you troubleshoot and resolve the errors. We validate the formula for correct syntax, circular references, and so on, as you create formulas. However, you can introduce formula errors as you make changes to your model structure. This includes changes to:

You can use the Formula Validation feature in Modeling to check all formulas, including account formulas, and formulas entered into sheets. It does not find formulas on reports.

After you run a validation, we provide information in the

Summary

section:

When the

Total Computations Required

is larger than the

Total Computations Performed

, you have reached the maximum errors. When the Formula Validation finds the maximum errors, it stops performing the computations of the remaining formulas. You must first resolve the displayed errors and then run the validation again.

In the

Error Details

section, we provide a list of errors with the account, level, and time period. The error message is a link to Explore Cell. From there, you can click through to resolve the error. For account default formulas, we list the error for every level. Resolving the error in the account settings fixes it for all levels.