Formula failure behavior

Formula failures in Planning Analytics for Microsoft Excel display as #VALUE, which can be an ambiguous Excel error indicator. In Planning Analytics for Microsoft Excel 2.0.89, the formula failure behavior was improved to simplify error identification.

Some #VALUE errors display as #NUM errors to represent a numeric error in a formula. #NUM can also mean that the input(s) are not in the range of valid metadata. Other errors continue to display as #VALUE to denote incorrect formula construction, including bad input type.