Archives of the TeradataForum

Message Posted: Fri, 01 Jun 2001 @ 17:46:44 GMT

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

I can share our experience from an insurance persepctive. We have two amounts, both are premium amounts, the first represents a change amount and is stored with positive\negative signs. The second is a full premium amount and is always expressed as a positive amount. What we found ourselves having to do to sum(the full premium amount) was to do a case statement that if x=value then y else y * -1. As we revise this table, we are storing the data as a signed value. I would think that if you ever will want to sum the data you will want to store it as a signed value.

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