Divide By Zero problem

[dxwallace]

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)

[mrcool]

use decode function and try 2 put '1' in place of '0'.

[dxwallace]

Thanks