Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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))) + 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,
this SQL calculation
need to calculate above expression calculation in Qlik sense but error occur please suggest me changes