Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

0 as blank

Greetings,


I would like the 0s in my report to just appear as blank.  Using conditional formatting in BI 4.1, I was able to accomplish this by formatting both the font and background the same color (white)

However, my attempt using conditional formatting below displays “” instead of blank:

    Filtered object or cell = my measure

    Operator = equal

    Operands = 0

    Format > Formula = “”

What should be the correct formula?

Regards,


replied

Hi Dee ,

No need of conditional formatting / formula .

Right click on column ->Format Number ->Custom

Positive #,##0 Negative [Red](#,##0) .Equal to 0 leave a space

2 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question