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?