Smart View Formula Displays #VALUE! Instead of Expected Value
Posted by Priya Doyle on 16 February 2011 11:55 AM
Applies to:Hyperion Financial Management - Version: 220.127.116.11.00 to 18.104.22.168.00 - Release: 9.2 to 11.1
Hyperion Essbase - Version: 22.214.171.124.00 to 126.96.36.199.00 [Release: 9.2 to 11.1]
Hyperion Enterprise - Version: 188.8.131.52.00 to 184.108.40.206.00 [Release: 6.5 to 6.5]
Hyperion Planning - Version: 220.127.116.11.00 to 18.104.22.168.00 [Release: 9.2 to 11.1]
Hyperion BI+ - Version: 22.214.171.124.00 to 126.96.36.199.00 [Release: 9.0 to 11.1]
Microsoft Windows (32-bit)
Microsoft Excel 2003 and Microsoft Excel 2007When 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.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.