topic Calculate sales in QlikView https://community.qlik.com/t5/QlikView/Calculate-sales/m-p/213803#M67461 <HTML><HEAD></HEAD><BODY><P>Thank you Karl</P></BODY></HTML> Mon, 14 Feb 2011 17:46:44 GMT 2011-02-14T17:46:44Z Calculate sales https://community.qlik.com/t5/QlikView/Calculate-sales/m-p/213801#M67459 <HTML><HEAD></HEAD><BODY><P>I am trying to calculate sales</P><P>Unitprice Discount : Discounts are stored on the transaction as a discount percentage.</P><P>Rate is exchange rate</P><P>sum (Qty* UnitPrice*Rate)-sum(Price*UnitPriceDiscount*OrderQty*Rate/100)</P><P>Looks like I am not doing something correct .</P><P>Please correct me <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P></P><P>Thanks</P><P></P><P></P></BODY></HTML> Sat, 12 Feb 2011 18:59:40 GMT https://community.qlik.com/t5/QlikView/Calculate-sales/m-p/213801#M67459 2011-02-12T18:59:40Z Calculate sales https://community.qlik.com/t5/QlikView/Calculate-sales/m-p/213802#M67460 <HTML><HEAD></HEAD><BODY><P>I'm confused by all the field names. Why do you have UnitPrice and Price? The formula might be better as:</P><P>sum( (UnitPrice * (1 - UnitPriceDiscount/100) * OrderQty * Rate)</P><P>Regards.</P><P></P></BODY></HTML> Sat, 12 Feb 2011 20:45:48 GMT https://community.qlik.com/t5/QlikView/Calculate-sales/m-p/213802#M67460 pover 2011-02-12T20:45:48Z Calculate sales https://community.qlik.com/t5/QlikView/Calculate-sales/m-p/213803#M67461 <HTML><HEAD></HEAD><BODY><P>Thank you Karl</P></BODY></HTML> Mon, 14 Feb 2011 17:46:44 GMT https://community.qlik.com/t5/QlikView/Calculate-sales/m-p/213803#M67461 2011-02-14T17:46:44Z