Loss of Precision in LEAST() Function

Analytics

Loss of Precision in LEAST() Function

Hello,

I am trying to use the LEAST() function to take the minimum of several decimal arguments, but the return value is rounded to the nearest 1. Is there a way around this?

Thanks,

Stephen

2 REPLIES
Junior Contributor

Re: Loss of Precision in LEAST() Function

Hi Stephen,

what's your Teradata release and the actual datatypes?

Re: Loss of Precision in LEAST() Function

Dieter,

I'm using Teradata version 14.0.0.1. The actual datatypes are both DECIMAL(9,2), but I've tested the function with other decimal precisions, and I have the same result.

Stephen