I'm trying to create a report that lists each invoice, but can also total by PO #, any ideas?
Just add a trailing grand summary part to your layout, and a summary field on the amount in the trailing grand summary part, and you'll be set.
If you go to add a new layout/report, try the report layout type and step through the creation. FMP will put it together for you, including adding the necessary fields, and then you can modify from there.
Even though the Project ID’s could be different on each invoice? Please bear with me, I am very new to this.
Absolutely. It'll total whatever records are on the report. If you place the invoice total amount in the body line, and the summary below in the trailing summary, you'll be fine.
Thanks! I’ll give it a try once I repair my invoice form and let you know!
Retrieving data ...