1 Reply Latest reply: Jul 14, 2011 10:48 PM by 787567 RSS

    How To ROUND the TAX following the Amout

    fdc-1992548
      Hi,

      How to add ROUND to TAX in this query :

      decode(rcta.ATTRIBUTE_CATEGORY,'Sales Order',NVL(AMOUNT_SO.AMOUNT_SO,0)+NVL(ADJUST_SO.ADJUST_SO,0),nvl(AMOUNT_VALAS.AMOUNT,0)) AMOUNT_VALAS
      ,decode(rcta.ATTRIBUTE_CATEGORY,'Sales Order',NVL(ROUND((AMOUNT_SO.AMOUNT_SO +NVL(ADJUST_SO.ADJUST_SO,0)) * rcta.EXCHANGE_RATE),2),nvl(ROUND(AMOUNT.AMOUNT,0),2)) AMOUNT
      ,decode(rcta.ATTRIBUTE_CATEGORY,'Sales Order',NVL(ROUND (NVL(DISC_SO.DISC_SO,0)+NVL(DISC_VALAS.DISC_VALAS,0),2),nvl(DISC_VALAS.DISC_VALAS,0))) DISC_VALAS
      ,decode(rcta.ATTRIBUTE_CATEGORY,'Sales Order',NVL(ROUND (NVL(DISC_SO.DISC_SO,0)+NVL(DISC_VALAS.DISC_VALAS,0),2) * rcta.EXCHANGE_RATE,0),nvl(DISC.DISC,0)) DISC
      ,TAX_VALAS.AMOUNT TAX_VALAS
      ,TAX.AMOUNT TAX

      Edited by: user11310796 on Apr 6, 2011 9:03 PM