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.
Quote[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.
Quote from: gosoccer on 04 Aug 2014 02:26:17 PM
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.
RESOLVED!!
YES, YES!! it worked. Thank you so much :) :)
Hi Gosoccer,
Can u please mention which database you are using.
The DB is oracle, but the data source is Cognos cube!