Home Page for the TeradataForum

Archives of the TeradataForum

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

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

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.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023