BI Publisher shows zero when is null — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BI Publisher shows zero when is null

Received Response
152
Views
5
Comments
1037520
1037520 Rank 4 - Community Specialist
in Oracle Analytics Cloud and Server

Summary

BI Publisher shows zero when is null

Content

Hello,

I have a report in bi publisher (layout builder not RTF) with a pivot table, when i run the report publisher sets as zero when the data does not exists.

 

Send a image with the example.

How can i change it ??

pdf.png

Thanks a lot.

Tagged:

Answers

  • Dir_Pal
    Dir_Pal Rank 6 - Analytics Lead

    Try masking the features from 0 to blank ..

    try format mask to null

  • Dir_Pal
    Dir_Pal Rank 6 - Analytics Lead

    image

    try this leave the numeric format blank

  • 1037520
    1037520 Rank 4 - Community Specialist

    Thanks for your answer, but what you said is for "obiee answers" and i'm working with BI Publiser (layout builder not RTF)

  • 1037520
    1037520 Rank 4 - Community Specialist

    yes, but i don't find where.

    Could you say me where can i change it please?

  • 1037520
    1037520 Rank 4 - Community Specialist

    I forgot saying that is in OBIEE 11g.

    Tnks