1 Reply Latest reply: Jul 5, 2014 9:11 AM by PAUL YEO RSS

    How to add Cell for round up into my expression ?

    PAUL YEO

      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