cancel
Showing results for 
Search instead for 
Did you mean: 

Numeric Format problem with 0 value

Former Member
0 Kudos

I have a numeric column in a Webi report. There are some values showing a 0. My customer doesn't want the 0 value to be shown, instead of it she wants the dash sign ( - ) to be shown, just like in Ms Excel.

I do right-click on the column and choose Number Format. Then I choose Number and any of the formats shown in the list. Then I check the Custom option. In the Equal to Zero box I input a dash sign because I want this sign - to be shown instead of the 0 values. But it doesn't work. Instead of the dash it shows a blank cell.

What can I do to solve this problem? Is it a bug in Business Objects XI?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

I'm don't know of this bug but you can use the formula to achieve what you need

=If variable/dimension/keyfigure = "0" Then "-"

Former Member
0 Kudos

>

> I'm don't know of this bug but you can use the formula to achieve what you need

>

> =If variable/dimension/keyfigure = "0" Then "-"

But my columns values are numbers not characters. If I'm not wrong in Desktop it was possible to choose a dash to be shown instead of a 0 value, but I don't know why WebI doesn't have the same behavior.

michael_melters
Advisor
Advisor
0 Kudos

You are right, WebI should behave like DesktopIntelligence with this, but it does not.

Meanwhile you achieve your formatting with an Alerter. Click in your report on your measure object and then on the Alerter symbol. In Sub Alerter box create an expression like:

YourMeasuresObject Equal to 0

then click on "Format..." -> In the Display box put your - sign -> in the Text box change Colour to "Standard".

Michael

Former Member
0 Kudos

You can actually drop the "0" to check it as an integer instead.

=If variable/dimension/keyfigure = 0 Then "-" Else variable

I'e actually tried it and it works. See here for before/after: http://yfrog.com/j3del2tpx

Former Member
0 Kudos

>

> You are right, WebI should behave like DesktopIntelligence with this, but it does not.

>

> Meanwhile you achieve your formatting with an Alerter. Click in your report on your measure object and then on the Alerter symbol. In Sub Alerter box create an expression like:

>

> YourMeasuresObject Equal to 0

>

> then click on "Format..." -> In the Display box put your - sign -> in the Text box change Colour to "Standard".

>

> Michael

Thank You! It works!!

Former Member
0 Kudos

Another way of doing this is in the universe designer, you can right click on dimension/measure, choose object format and then in the number format add \- in the 'Equal to Zero' box. This way you dont have to add formula in each report.

Edited by: salah1 on Sep 7, 2010 11:28 AM

Former Member
0 Kudos

Yes. It is always a better design apporach to have the formatting at the Universe level rather than the webi/deski level.

Former Member
0 Kudos

>

> Another way of doing this is in the universe designer, you can right click on dimension/measure, choose object format and then in the number format add \- in the 'Equal to Zero' box. This way you dont have to add formula in each report.

>

> Edited by: salah1 on Sep 7, 2010 11:28 AM

Thanks for your post!

I was wrong when using the Format Number option in WebI because I was putting just the dash sign and with your post now I know that I had to use a backslash sign like you mention \- , instead of just placing in the 'Equal to Zero' box this - sign.

So it works not only in Universe Designer but in WebI too.

Answers (0)