Smart View Formula Displays #VALUE! Instead of Expected Value

Smart View Formula Displays #VALUE! Instead of Expected Value
		Modified 07-MAY-2010     Type PROBLEM

---

Applies to:

Hyperion Financial Management - Version: 9.2.0.0.00 to 11.1.1.3.00 - Release: 9.2 to 11.1
Hyperion Essbase - Version: 9.2.0.0.00 to 11.1.1.3.00   [Release: 9.2 to 11.1]
Hyperion Enterprise - Version: 6.5.0.0.00 to 6.5.1.0.00   [Release: 6.5 to 6.5]
Hyperion Planning - Version: 9.2.0.0.00 to 11.1.1.3.00   [Release: 9.2 to 11.1]
Hyperion BI+ - Version: 9.0.0.0.00 to 11.1.1.3.00   [Release: 9.0 to 11.1]
Microsoft Windows (32-bit)
Microsoft Excel 2003 and Microsoft Excel 2007

Symptoms

When attempting to refresh a Smart View sheet that contains formulas(not Ad Hoc), the cell displays #VALUE! instead of the expected value.  This is an Excel message, not a Smart View message.

Cause

This is caused by an issue with the Excel formula.  Specifically, the #VALUE! error value occurs when the wrong type of argument or operand is used, or if the Formula AutoCorrect feature cannot correct the formula.  The most common cause is trying to to use a math operand on a non-numeric value.

If a simple Smart View formula would return #MISSING, #NOACCESS, or some other non-numeric value and the more complex Smart View formula has additional operands on the end like /1000 or *.1, this will occur.

Solution

1. Remove all other Excel functions from the Smart View formula.
   
2. Address the underlying issue by either correcting the formula or by changing the Smart View Replacement values under Smart View Options, Display.