0 as blank

[Former Member]

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,

[sateesh_kumar1 · Accepted solution]

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

[Former Member · Accepted solution]

Hi Sateesh,

I learned something new. I followed your example and it worked beautifully. 

Can you please let me know where I can find resources/documentations/links etc  for similar and related report techniques?

Regards,

[sateesh_kumar1 · Accepted solution]

Hi Dee,

SCN is the best place to learn .Go to Content tab in the space ,search for documents and blogs.

Explore in WebIntelligence XI also.

[Former Member]

Your formula would be ="" instead of just ""

[Former Member]

Thanks everyone for your helpful replies!

Regards,

[nscheaffer]

Rather than formatting the the 0 so you cannot see it I think it would be better to create a variable.

=If([YourData]<>0;[YourData])

This will result in a NULL value for the variable if the original variable value is 0.

Noel