First time here? Check out the FAQ!

Null values in the application.

0 votes
asked by about Hyperion Intelligence Explorer
edited by

I'm using Hyperion IE V8.3. I'm trying to add the sum of 2 fields in the request line. However, the fields contain nulls. When I sum the values, I get a totally different # in the results vs sum the values in a pivot. Is there a way in the request line to make the null values zero and then sum?

1 Answer

0 votes
answered by (236k points)

The NULL values are caused by a missing number, element, formula and the hastag is displayed every time there is an error in the calculation. If you use a formula, check the elements contained in the SUM. No, you can't mark the NULL values as zero since they contain errors.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register