Archives of the TeradataForum

Message Posted: Thu, 20 May 2004 @ 21:14:14 GMT

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

<-- Anonymously Posted: Thursday, May 20, 2004 16:56 -->

Did you try -

     (cast(c.local_hhld_univ as decimal(15,2)) / cast(cs.natl_hhld_univ as decimal(15,2))) as Market_Alloc,

For second problem try having some dummy avg or min or max func to avoid the group by.

Thanks.

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