I'm trying to write a purchase order report. All I want is one line on the report for each purchase order that has a total PO value greater than $100,000. Since the total PO cost is not saved in the Purchase Header Table I need to Sum the data in the Purchase Line table. I figured out how to do this using the "Sum(Amount) >100000.00" in the filter of the purchase line table. My problem is that the report is printing the line for some of the PO's multiple times.
How do I eliminate the duplicate lines?
Date
Votes
1 comment
-
Harry Lewis Hello Margaret -
Similarly to the previous question you asked, use an NL(Rows) function on the Purchase Header Table and an NL(Sum) to add up the Amounts in the Purchase Line. Use a modified version of your NL(Sum) as a filter in the NL(Rows)...
Please sign in to leave a comment.