Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Financial Reporting - null values

818681Nov 29 2010 — edited Nov 30 2010

Hello,

I am new with Hyperion Financial Reports and I have a quick question : I'm on the production environment and I'm facing the following issue with a report defined in FR: I have defined a new column formula (the formula is col[C]=col/col[A]). For some rows the result returned is error, because for those rows there are no values defined for col[B] or col[A], there are null values.

I cannot suppress the rows.

1. How should I treat the null values in the report ? Is there any function that I can use like "if col[B] Is Null then 0 else col[B]\col[A]" in order to avoid the error cells ?

Thank you,
Iulia

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 28 2010

Added on Nov 29 2010

#business-intelligence-applications, #hyperion, #performance-management-applications, #planning-and-budgeting, #reporting

3 comments

947 views