![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Fri, 01 Jun 2001 @ 17:46:44 GMT
Subj: | | Re: Transaction Debits and Credits |
|
From: | | Jim Downey |
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.
| |