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.

devide_zero_1

 

To avoid this result go to:

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

devide_zero_2

 

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

Leave a Reply

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