This discussion has been locked.
You can no longer post new replies to this discussion. Posts are automatically locked, when no new replies have been made for a long time. If you have a question you can start a new discussion.

SUM(Quantity) Report

Hey Everyone,

So I'm trying to create a report that sums the quantity of a product we sell. Currently I'm using a flowfield located in the customer table that looks like this:

[code] Sum("Sales Invoice Line".Quantity WHERE (Sell-to Customer No.=FIELD(No.),No.=FILTER(A|B|C))) [/code]

However, I need to filter by SalesInvoiceLine."Document No." so that it only counts the quantity when the Doc# is unique. I'm almost positive this isn't the best way to go about it, so any suggestions are appreciated.

So essentially I want to count the number of unique Sales Invoice Headers a customer has but only if the Sales Invoice Line."No." = A|B|C. My questions to you all are: 

a) Should I be hardcoding this all into the report, instead of using flowfields in the customer table? (If so, I'll show you what I have coded in c/al so far)

b) Would it make more sense to use a count(sales header) and then filter on the sales somewhere in the report?

Thanks for your help! Any and all suggestions are welcome.