Calculate sales

[#1]

I am trying to calculate sales

Unitprice Discount : Discounts are stored on the transaction as a discount percentage.

Rate is exchange rate

sum (Qty* UnitPrice*Rate)-sum(Price*UnitPriceDiscount*OrderQty*Rate/100)

Looks like I am not doing something correct .

Please correct me 🙂

Thanks

[pover · Accepted solution]

I'm confused by all the field names. Why do you have UnitPrice and Price? The formula might be better as:

sum( (UnitPrice * (1 - UnitPriceDiscount/100) * OrderQty * Rate)

Regards.

[#3]

Thank you Karl