https://community.qlik.com/t5/QlikView/round-and-sum-function/m-p/2077201#M1223896 <P>Hi everyone,</P> <P>Round( Sum(((Posi_Qty * (Posi_Rate - Nvl(Posi_Rate * Posi_Disc_Perc / 100, 0) - Nvl(Posi_Disc_Amt, 0))) <BR />+ Nvl(Posi_Loose *(Posi_Rate - Nvl(Posi_Rate * Posi_Disc_Perc / 100, 0) - Nvl(Posi_Disc_Amt, 0))/Uom_Max_Loose, 0))),2) Sale_Amt,</P> <P>Null Ret_Amount,</P> <P>this SQL query calculation if used same in Qlik&nbsp; sense error occur please guide me how i will change this expression so it will work on Qlik sense</P> Mon, 29 May 2023 08:00:15 GMT AnkitaC 2023-05-29T08:00:15Z https://community.qlik.com/t5/QlikView/round-and-sum-function/m-p/2077201#M1223896 <P>Hi everyone,</P> <P>Round( Sum(((Posi_Qty * (Posi_Rate - Nvl(Posi_Rate * Posi_Disc_Perc / 100, 0) - Nvl(Posi_Disc_Amt, 0))) <BR />+ Nvl(Posi_Loose *(Posi_Rate - Nvl(Posi_Rate * Posi_Disc_Perc / 100, 0) - Nvl(Posi_Disc_Amt, 0))/Uom_Max_Loose, 0))),2) Sale_Amt,</P> <P>Null Ret_Amount,</P> <P>this SQL query calculation if used same in Qlik&nbsp; sense error occur please guide me how i will change this expression so it will work on Qlik sense</P> Mon, 29 May 2023 08:00:15 GMT https://community.qlik.com/t5/QlikView/round-and-sum-function/m-p/2077201#M1223896 AnkitaC 2023-05-29T08:00:15Z