Knowledgebase: Enterprise
Hyperion Enterprise Retrieve Displays #VALUE with HPVAL Formula
Posted by Priya Doyle on 15 February 2011 05:27 PM

Hyperion Enterprise Retrieve Displays #VALUE with HPVAL Formula

 Modified 11-AUG-2010     Type PROBLEM  

Applies to:

Hyperion Enterprise - Version: and later   [Release: 5.0 and later ]


Hyperion Enterprise Retrieve displays #VALUE with HPVAL formula.

The POV settings in Retrieve appear correct


The actual value in the period option is not the displayed value due to Excel formatting.
Although it appears to be MAR 03 in the formula bar it is really 3/3/04 as an example.


From within Excel, in the cell which references the period, either enter the period number (i.e.1 for Jan Etc) or use the CHANGE PERIOD option from the RHXL menu to populate the period cell with a correctly formatted period value.

Once done refresh the sheet and ensure the values are now displaying as expected.

(0 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name: