Divide by zero

In a cognos report you can get ‘/0’ as a result in a table.
This is because in that field the calculation is /0.



To avoid this result go to:

– Click on the crosstab intersection
– Choose Data –> Dataformat –> a new box pops up



– Format type: percent
– Device by Zero Characters:  choose ‘-‘

Leave a Reply

Your email address will not be published. Required fields are marked *