Showing the "/" before 0 when the # of transaction is zero in Report Author 10.1

[gosoccer]

Friends,
We are using Report Author 10.1.2 using the OLAP cube dimensional hierarchy data set.

I am using the following expression to show the percentages in our report.

[Total(# of Success)] / [(Total(# of Failure) + Total(# of Success))]

it is working absolutely fine except when the expression is 0 since the count is 0 (for # of success and # of failure)  the report shows a "/" before the 0 count.

Please see attached and let me know if there is anyway I can get rid of this unwanted "/"
Thx so much.

[MFGF]

Friends,
We are using Report Author 10.1.2 using the OLAP cube dimensional hierarchy data set.

I am using the following expression to show the percentages in our report.
it is working absolutely fine except when the expression is 0 since the count is 0 (for # of success and # of failure)  the report shows a "/" before the 0 count.

Please see attached and let me know if there is anyway I can get rid of this unwanted "/"
Thx so much.

Use the data format property, and set the "Divide by zero characters" within this.

Cheers!

MF.

[gosoccer]

RESOLVED!!
YES, YES!! it worked. Thank you so much :) :)

[sunny bachan prasad]

Hi Gosoccer,
Can u please mention which database you are using.

[gosoccer]

The DB is oracle, but the data source is Cognos cube!