Archives of the TeradataForum

Message Posted: Fri, 12 Nov 2004 @ 09:23:34 GMT

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

Mathematically, this task can easily be reduced to SUM via the EXP(LN) route. However, we are in the numeric field, and rounding is an important factor here. You might try this method and see whether the rounding is acceptable to you.

Stored procedures could be an alternative if the volumes are not high.

Regards,

Victor

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