it can be a portal refresh issue. To test this, add a button to your Layout that you will remove after the test. The button action will be to refresh the portal, for FMP 14+ use Refresh Portal, for FMP < 14 use Refresh Object. Once a a field has been changed, click the button: if you get the right result, you know it's a refresh problem.
If you can, attach a script trigger to a record being updated, and refresh the portal.
In your Contracts table you should have calculations like:
Put those 2 fields under (or above) the appropriate column in your portal.
The above is predicated on your having a relationship similar to ID Contract = RelatedTable id contract.
On the File / Manage / Database screen, when I defined the total fields, instead of defining them as text, number, date or calculation type, using the formulas you suggest, I pick Summary Fields and I choose "total of:" Related Table::desired field... That's why I call them Summary fields, and I guess they are unstored calculations
It should work. It looks as they were paused in a script
Anyway, I'll try your suggestion
The total fields I was using were in the Payments table, and that caused the problem...
When I set them again (moved) to the Contracts table, everything went well
1 of 1 people found this helpful
Your summary fields will work on the Invoice layout depending on how you sort the Invoice records, but best as I can tell, you are looking at related Invoices from the Contracts layout through a portal. There you need to sum the records that relate to each Contract.