1 Reply Latest reply: Aug 24, 2011 1:19 AM by Kaushik Solanki RSS

    sql case statement during edit script loading

    Ruby Otero

      hi i have a SQL table as my souce data and i want to effect this change in data representation



      date field are

      TRCD  - numeric date referrring to transaction code (1=invoice and 3 =returns)

      AMT - amt (no negative value)


      what i want to achieve is when trcd=3 amt will represent data in negative status so that when i sum(amt) it will give me net sale




      amt= 1000