Skip to Main Content
Forums

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!

Replacing Nulls with 0 in Pivot

769623Oct 19 2010 — edited Dec 2 2010
Hi All,

I am using an union request , i need to display 0's in place of nulls. I tried different methods like ifnull(), Case; i was able to see 0's in table but not in pivot.
I tried and succeeded in placing '-' instead of null. If i put a line chart the chart looks meaningless.
Can anybody suggest me this on chart & pivot.

Thanks in advance,
Princy
This post has been answered by Kranthi.K on Oct 19 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 30 2010
Added on Oct 19 2010
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
15 comments
765 views