This discussion is archived
1 Reply Latest reply: Jul 14, 2011 8:48 PM by 787567 RSS

How To ROUND the TAX following the Amout

fdc-1992548 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points