Archives of the TeradataForum
Message Posted: Fri, 18 Apr 2008 @ 22:40:19 GMT
Here what I think might be happening:
The normal output data type from AVG is float. As far as I have seen, it is the only place where the data type coming out is not the same as the data type going into it.
On the second one, you are converting/forcing the float to a decimal attribute and getting more accuracy with the .25 versus the .00.
Hope this helps,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|