looks like I fixed it myself : CASE WHEN NULLIF({fxamount}, 0) !=0 THEN NULLIF({fxamount}, 0) / NULLIF({quantity}, 0) ELSE NULL END