Summarizing Repeating Fields
I'm using FM Pro 11 Advanced. I have an invoicing module with 6 repeating fields for Quantity, Line Item, and price and so on. I look-up the Line Item from a Products file (30+ products), enter the Quantity and the rest of the invoice is calculated as expected. At the end of a period of time (day, Month, or whateverthat) I choose, I want to count the quantity of each product that has been invoiced. Since any product may be listed on the invoice on any of the (6) repeating Line Item repeats, I'm uncertain how I can do this.
Any Ideas out there?