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!

ifnull '$0' in conditional formatting

user3307493Dec 12 2012 — edited Dec 12 2012

Hi,
Users want to see '$0' when there is null value in 'Net Sales' column. I have applied - IFNULL("- Agg Inv Line"."Net Sales (Vendor)",0) in the formula but it doesn't work when I pivot with other dimension.

I want to insert '$0' when this Sales Amount is Null using Conditional Formatting. I tried to Custom Data Format --> Override Default Data Format -> HTML but it's not taking "$0" when Amount is NULL.

I would really appreciate if somebody can explain how to implement this.

Thanks..

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 9 2013

Added on Dec 12 2012

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

1 comment

174 views