Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Paul,
I solved your issue by using a preceding load. Take a look at the attachement.
Cheers,
Michiel
My QV doc.
Hi Paul,
I solved your issue by using a preceding load. Take a look at the attachement.
Cheers,
Michiel
Hi Michiel
Thank you very much , you are right partial reload is the right apporach . also load script make my expression more simple and less error , now i can move on,
Paul