Archives of the TeradataForum

Message Posted: Tue, 15 Nov 2005 @ 14:05:15 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Andene:

If you are getting a numeric overflow you are casting too late. You need to change the data type before the calculation. I don't know the data type of either balance nor irate, but you can adjust it as needed in doing something like:

     Case when Rate = 'Credit'
          then (balance(dec(16,2))* Irate)/12*100 end

Hope this helps,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

	<Prev	Next>		<<First	<Prev	Next>	Last>>