I am trying to create a calculated field:
sel
tma_pk_hmmou/tot_allow_min as varianc
from table_x
format of tma_pk_hmmou is decimal(7,2)
format of tot_allow_min is integer
I am getting values of 0, 1, 2, 3, etc. I want decimal values. That is, if I divide 223 into 400, teradata is giving me...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.