If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Getting blank cell while calulating the percentage in list report

Started by sunny bachan prasad, 02 Aug 2014 10:51:08 PM

Previous topic - Next topic

sunny bachan prasad

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

MFGF

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.
Meep!

sunny bachan prasad

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.

gosoccer

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!!

Lynn

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?

MFGF

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.
Meep!

sunny bachan prasad

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

Lynn

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.

gosoccer

Just a warning, if you use Case Statements within the report, it'll cause a tremendous slowness!!!!~~

Lynn

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!!

sunny bachan prasad

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.

saikumar_naani

Could you share me the expression how did you converted the number to percentage with the symbol displying for atleast the original values.