Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

paulyeo11
Valued Contributor II

How to add Cell for round up into my expression ?

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

1 Reply
paulyeo11
Valued Contributor II

Re: How to add Cell for round up into my expression ?

My QV doc

Community Browser