How to Round up display Rp 7,940,613.33 to Rp 7,940,614
My Org script is below :-
if(match(Currency_P,'SG'),
money(
AFTER_DISCOUNT*X_RATE*TRANS_SUP/MU_TDS,
CurrencyFormat_P),
if(match(Currency_P,'INDO'),
money(
AFTER_DISCOUNT*X_RATE*TRANS_SUP/MU_TDS*RATE_ID*TAX_*DUTY_*TRANSPORT_SUB,
CurrencyFormat_P),
if(match(Currency_P,'MY'),
money(
AFTER_DISCOUNT*X_RATE*TRANS_SUP/MU_TDS*RATE_MY*TAX_*DUTY_*TRANSPORT_SUB,
CurrencyFormat_P),
if(match(Currency_P,'THAI'),
money(
AFTER_DISCOUNT*X_RATE*TRANS_SUP/MU_TDS*RATE_TH*TAX_*DUTY_*TRANSPORT_SUB,
CurrencyFormat_P)
))))
How to add below to above expression :-
(Ceil(
AFTER_DISCOUNT*X_RATE*TRANS_SUP/MU_TDS,
,0.5)
Hope some one can help me.
Paul
