Hi Cognos Guru's,
I am creating report using report studio.In that i have to show the percentage in one column of the list but some of the cell of the output report is coming blank as some value in the other measure is zero which is coming in the denominator while calculating the percentage.Can any one know how to solve it.I am using IBM Netizza database.I tried the data format option but it is not working.Can anyone came with the same problem earlier.Please help its urgent.
Thanks in Advance
Quote from: sunny bachan prasad on 02 Aug 2014 10:51:08 PM
Hi Cognos Guru's,
I am creating report using report studio.In that i have to show the percentage in one column of the list but some of the cell of the output report is coming blank as some value in the other measure is zero which is coming in the denominator while calculating the percentage.Can any one know how to solve it.I am using IBM Netizza database.I tried the data format option but it is not working.Can anyone came with the same problem earlier.Please help its urgent.
Thanks in Advance
Hi,
If the denominator is zero, what would you expect the result of the expression to return?
The easy answer should be to set the data format to percent and then set the "Divide by zero characters" to whatever you wish to display.
Cheers!
MF.
Hi MFGF,
Thanks for your reply.Whatever you have mentioned i already tried as i mentioned in my earlier post but still i am getting blank cell.
The IBM Netizza database may have this option but the most efficient way to do this is to have the zero suppressed at the generation time. We are using cubes (OLAP) and all I had to do is to select the option to suppress zero when there is a null. This way, the data as a part of the report is established correctly without additional manipulation at report level.
Hope this help!!
The divide by zero property is explained like this:
QuoteSpecifies the characters to be displayed when a numeric value is the result of a division by zero. The default value is /0. Note that the format will be applied only if the data source supports this error condition.
Since you are getting a blank rather than the /0 default and since you tried specifying a value but still got blanks, I suspect your data source may not support that error condition.
How about the Missing Value Characters property?
Quote from: Lynn on 05 Aug 2014 03:27:02 PM
The divide by zero property is explained like this:
Since you are getting a blank rather than the /0 default and since you tried specifying a value but still got blanks, I suspect your data source may not support that error condition.
How about the Missing Value Characters property?
I'm constantly amazed by the insight of so many people here on Cognoise! Now you say that, it makes total sense! :)
Have an "Applaud" from me! :)
MF.
Lynn,
I tried that also but that is also not giving the correct answer.
I am not sure whether Netizza support this property or not.
Other thing i want to let you cognos's Guru is that i am not using any cubes right now for generating the report
Quote from: sunny bachan prasad on 06 Aug 2014 11:05:00 AM
Lynn,
I tried that also but that is also not giving the correct answer.
I am not sure whether Netizza support this property or not.
Other thing i want to let you cognos's Guru is that i am not using any cubes right now for generating the report
Not sure what you mean by "not giving the correct answer". Does that mean it is still blank even with the missing values property specified? Are you specifying the property on the calculated column or on the denominator? You need to do it on the calculation because this is only going to affect the DISPLAY of the information...it isn't going to change the underlying value of the denominator or the calculation in your query.
Maybe you should interrogate both the numerator and denominator to understand what is going on. Maybe try using a case statement to detect the zero denominator and just explicitly set a value.
Just a warning, if you use Case Statements within the report, it'll cause a tremendous slowness!!!!~~
Quote from: gosoccer on 06 Aug 2014 11:31:41 AM
Just a warning, if you use Case Statements within the report, it'll cause a tremendous slowness!!!!~~
Very true!!
Hi Lynn,
you are right.I am getting the blank cell only even after applying the data format on the calculated data item which containing the formula for the percentage.
Could you share me the expression how did you converted the number to percentage with the symbol displying for atleast the original values.