Archives of the TeradataForum

Message Posted: Fri, 25 Feb 2011 @ 13:55:46 GMT

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

I use TD SQL Assistant v13 and Nexus v5 to query TD. I have the same challenge in both, so I think it may be my SQL syntax

I am trying to create percentages. I have simplified my SQL to the following, for discussion purposes:

     select
     cast( (3995852 * 100 / 12274677) as Decimal(6,3) ) as Data_Pct

The result I receive is 32. But the result that I expect is 32.554.

I have tried adding a FORMAT clause but that seems to not make a difference either. Suggestions?

Attila Finta

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