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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
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