Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
AnkitaC
Contributor II
Contributor II

round and sum function

Hi everyone,

Round( Sum(((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,

Null Ret_Amount,

this SQL query calculation if used same in Qlik  sense error occur please guide me how i will change this expression so it will work on Qlik sense

Labels (1)
  • Other

0 Replies