Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have one expression is working fine , only have 1 condition :-
if(match(Currency_P,'ID'),
i like to make additional condition on :-
if(match(Currency_P,'ID'),
My Org Expression is below :-
if(match(Currency_P,'SG'),
money(
(
Ceil(
AFTER_DISCOUNT*X_RATE*TRANS_SUP/TDS_MU
,0.5)
)
,CurrencyFormat_P),
money(
(
Ceil(
floor(ceil(AFTER_DISCOUNT*X_RATE*TRANS_SUP/TDS_MU/MARKUP_SUB*RATE_ID*TAX_*DUTY_*TRANSPORT_SUB,.5), .1)
,0.5)
)
,CurrencyFormat_P)
)
I modify the below :-
if(match(Currency_P,'SG'),
money(
(
Ceil(
AFTER_DISCOUNT*X_RATE*TRANS_SUP/TDS_MU
,0.5)
),CurrencyFormat_P),
if(match(Currency_P,'ID'),
money(
(
Ceil(
floor(ceil(AFTER_DISCOUNT*X_RATE*TRANS_SUP/TDS_MU/MARKUP_SUB*RATE_ID*TAX_*DUTY_*TRANSPORT_SUB,.5), .1)
,0.5)
)
),CurrencyFormat_P)
)
Above is not working.
Hope some one can help me.
Paul
My QV Doc