Hi, please forgive if the answer is obvious as I am new to Filemaker. I have two tables - Invoice and InvoiceItems. The invoice items are displayed in the Invoice using a portal. When I use the 'sum' function to give an invoice total, a blank is returned. What's up?

What field have you chosen to make the sum from, it should be a line total field given the syntax:

relationname::fieldname

...which means that if you in each line sell more than one item, could it be a calculation-field containing this:

itemCount * ItemPrice

...where the itemPrice very often is a historic value looked up from a different table with itemID as key.

--sd

Thank you Soren for your reply. You are absolutely right. The sum is a line total of numberOfItems*Price. The Price is a lookup from the product table. Is this the reason that I am drawing a blank? If so what should I do? Regards.

Well it seems like some of the relations you're using are belonging to another TOG, what if you upload an empty clone of your stuff so I can inspect it?? You can also send it to me privately if your wish??

--sd

Hi, What's a TOG? Thanks for the offer of inspecting the files. I have uploaded them. I much appreciate it. You can email direct to me if you like at [email protected]. Thanks.

New_Compressed__zipped__Folder.zip

Set your total to be an unstored calculation, not a number with an auto-entered calculation. Changing related values will not update a field with an auto-entered calculation.