Common Formula Errors
- Incorrect syntax. For example, to divide:
- Data privacy. The account must be public at all levels to reference another level.
- Invalid accounts. Make sure the account name you entered is spelled correctly. Use the Formula Assistant to prevent account syntax errors.
This section includes some troubleshooting tips for fixing formula errors.
Issue: Cannot Edit Shared Formulas for a Version
If you have Administrator permission, but shared formulas are not editable for a version, navigate to Modeling > Versions and check the following:
- Make sure Administrators have Full Access to the version.
- Check to see if the version is locked (Locked version). You cannot edit shared formulas in a locked version.
- Check to see if Locked leading months through is set for the version. Because shared formulas must work across time periods, having any month set in this feature locks the entire Shared Formulas page
Issue: "Expected a literal numeric value" Error Appears
Typically, when you get this error, it's because the equal sign (
=) is included in the formula. This sign is not required when you use the Formula Assistant. Remove the = sign and try again.
Issue: Changes to Shared Formulas Don't Appear in All Locations
If you update a shared formula, check to see if a user has overridden the shared formula on a sheet. When you update the formula, you have the option to Remove user edits as part of the update.