3 Replies Latest reply: Sep 2, 2014 8:34 PM by PAUL YEO RSS

    How to write a expression when reload it will convert all diff currency to SGD $

    PAUL YEO

      Hi All

       

       

      I create this expression at table column for 30DaySGD , it work fine :-

       

       

      IF(CURRENCY='EUR',COLUMN(1)*1.64,

      IF(CURRENCY='NT',COLUMN(1)/24,

      IF(CURRENCY='USD',COLUMN(1)*1.25,

      IF(CURRENCY='YEN',COLUMN(1)*0.012,

      IF(CURRENCY='SGD',COLUMN(1)*1))

      )))

       

       

      My load script have following field :-

       

       

      @220:223T as [CURRENCY],

       

       

      @92:106T as [30DAY_],

       

       

      @107:108T as [30SIGN],

       

       

      if(@107:108T = '-',@92:106T*-1,@92:106T) as DAY30,

       

       

      May i know how to write the expression , so that when it load script , it will create the field for Day30SGD ?

       

       

      Paul