I am creating report using cognos 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. >:( >:( >:(
There should be line in the Data Format window for Missing Values. I think you can specify what to show when the cell is Null.
Or
come up with a case statement if (% is not null) then (%) else (0)