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

How show 0% in OBIEE

Received Response
2
Views
7
Comments
Roberto Ibáñez Martínez
Roberto Ibáñez Martínez Rank 1 - Community Starter
edited Aug 13, 2024 6:01PM in Oracle Analytics Cloud and Server

Hi!

I want to show a 0% in OBIEE. How I can do it?

Sin título.png

Thanks

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    What's that column? Where does it come from?

    It looks like a duplicate inside the pivot and then selected a "display as %", is that right?

    In that case I would say that the empty cell is the right one and you cheated on the format on the columns next to the % to display 0 when there is no data.

    No data is different than 0 or null, so with no data there can't be a % calculated....

  • Roberto Ibáñez Martínez
    Roberto Ibáñez Martínez Rank 1 - Community Starter

    I´ve used IFNULL function previusly to cange NULL for 0s.

  • Gianni Ceresa
    Gianni Ceresa Mod

    No data is not null !

    So do you have data? Is that data null?

    Or there is just no data for these cells?

  • Roberto Ibáñez Martínez
    Roberto Ibáñez Martínez Rank 1 - Community Starter

    Values come from outer join and they don't cross. I used IFNULL to change NULL for zero. The user wants to show 0 % in this case.

    I also try to change the formar of  data: #,#%;-#,#%;0,0% . It´s not working. Do you know how to force show 0%?

    Thank you very much.

  • Gianni Ceresa
    Gianni Ceresa Mod

    What's behind that column? What formula did you use or how did you display that column? (I assumed something earlier but you still didn't clearly said what's that thing ...)

  • Roberto Ibáñez Martínez
    Roberto Ibáñez Martínez Rank 1 - Community Starter

    Sorry, your assumptions were correct that's why I didn't say anything.

    - We duplicate inside the pivot and then selected a "display as %".

    - The empty cell is the right one and we cheated on the format on the columns next to the % to display 0 when there is no data.

  • Gianni Ceresa
    Gianni Ceresa Mod

    A bad news and a good news for you

    The bad one is that you can't do anything at the analysis level to get 0% instead of empty (because it's actually really empty). The "display as" doesn't give you any control on the format of the column.

    The good news is that if you calculate the % yourself with a formula (so a real column producing the %) you can use the same approach as the one on the left: define a custom format showing 0% when empty.