topic error occur in qlik sesne in App Development https://community.qlik.com/t5/App-Development/error-occur-in-qlik-sesne/m-p/2077193#M88380 <P>Hi,</P> <P>ROUND(sum(DECODE(POSI_TXN_TYPE, 'S', 1, 'R',0, 1)*((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>this SQL calculation</P> <P>need to calculate above expression calculation in Qlik sense but error occur please suggest me changes</P> Fri, 15 Nov 2024 21:45:32 GMT AnkitaC 2024-11-15T21:45:32Z error occur in qlik sesne https://community.qlik.com/t5/App-Development/error-occur-in-qlik-sesne/m-p/2077193#M88380 <P>Hi,</P> <P>ROUND(sum(DECODE(POSI_TXN_TYPE, 'S', 1, 'R',0, 1)*((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>this SQL calculation</P> <P>need to calculate above expression calculation in Qlik sense but error occur please suggest me changes</P> Fri, 15 Nov 2024 21:45:32 GMT https://community.qlik.com/t5/App-Development/error-occur-in-qlik-sesne/m-p/2077193#M88380 AnkitaC 2024-11-15T21:45:32Z