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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
AnkitaC
Contributor II
Contributor II
‎2023-05-29 04:00 AM

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)
Labels

  • Other

720 Views
0 Likes
0 Replies