Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Note: You may notice some temporary visual or styling issues in the Community. Our vendor is actively investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
AnkitaC
Contributor II
Contributor II

error occur in qlik sesne

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

Labels (1)
0 Replies