you do not use ' when data type is float
you should write: Select case when A_AMT = 0 then ... else A_AMT end from table_a