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

       

      ex.

      trcd=1

      amt= 1000

       

      trcd=3

      amt=(1000)