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
