I thought this was easy, yet I cannot get it. I have an order form. Product and amount to order. It is not in FileMaker. I imported the records into FM and need to calculate the amount ordered per item and create a report to order the product.
I have tried several calculations and the proper number is not being returned.
Right now there are only 20 orders, but there will be close to 100, Virtually every field for multiple submissions needs to be rolled into a calculated report.