Display only one instance of a discount for an invoice
Need some help with a Qlikview report I wrote.
The report shows how much discount was given on each invoice. The problem I have is if the invoice have more than 2 items, the discount is displayed twice on the report. How do I get the report to only show me the discount once?
I am using the Expression "discount" and using the definition
Re: Display only one instance of a discount for an invoice
Max(discount) is the function I am using to grab the the discount values. As I mentioned, if the invoices have more than one line to them (more than one item), then the report displays the discount on each item line. I just want to see the discount amount once.