Hi All,
I am DEFINEing a columns using two fields as (PRICE/AVG_PRICE)*100.

What will happen, if AVG_PRICE is null or 0. Will it throw error? If yes, how to handle such scenario. Please advise.

Many Thanks.

This message has been edited. Last edited by: <Emily McAllister>,

SET %STRICTMATH='OLD' will return zero as the output if the AVG_PRICE is zero or MISSING.

By default, it SET %STRICTMATH='NEW', in this case it will give a error

(FOC201) INTERRUPT. DIVISION BY ZERO
or
You may get a wrong value.