Summary issue

[topjobs]

Sorry if this question has been posted, but I can't find the answer.

 

I have a summary report showing a list of vendors, and the amount paid for a defined period of time. We have 2 fields in this report "Vendor" & "Purchased" (summary field) in the report. We didn't purchased anything from some of the vendors, but they still show in the report. I would to only show vendors that have an amount in the "Purchased" field.

 

Thank you.

[comment]

It sounds like you should start by finding records whose date is within the report's date range AND whose amount is not empty or 0.

[topjobs]

OK, and how do I do that?

[comment]

Enter Find Mode[]
Set Field [ YourTable::Purchased; "> 0" ]
Perform Find []

This will find records where the Purchased field contains an amount greater than zero. You didn't tell us anything regarding the data range, so I can't suggest anything there. See:

http://www.filemaker.com/help/13/fmp/en/html/find_sort.5.8.html#1028153