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!

FR-studio Conditional formula

710349Nov 5 2009 — edited Nov 5 2009

Hi All ,

I am using Hyperion Financial reporting studio for creating reports.
My requirement is I want to show Blank value in a column if the value in another column is ZERO or MISSING else it will show the Variance.
For doing that I am using this formula :

IfThen((IsMissing([C]) OR [C]=0), 'Blank' ,Variance(,[C])).

Can any one tell me what should I put in place of blank in the above formula to achieve the above stated requirement?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 3 2009

Added on Nov 5 2009

#business-intelligence-applications, #business-intelligence-foundation, #hyperion-query-and-reporting

3 comments

1,206 views