Divide By Zero Problem

[theWavist]

How Do I write a calculation for a numeric data item that keeps giving me teh value of "/0" ?

the way I am currently writing it is

((fieldA - FieldB) / FieldB ) * 100)

 

[blom0344]

You'll have to decide om the value of the calculation for a zero value of FieldB.
One solution is a case-construct::

CASE WHEN
FieldB = 0 THEN << certain value >>
ELSE ((fieldA - FieldB) /  FieldB ) * 100) END

However Cognos may have it's own solution for divide by zero problems..



Ties Blom