Calculation doesn't work in layout

[Tmonk]

Hi!I am having a problem with a calculation not working with the layout I need it to work on. I have 2 tables, Player, and Financial. There is a second instance of Financial called "Enter Financial". I have a layout whose primary table is Player. There is a portal where records from financial are listed. I have fields on my "Player Layout" where I enter data in fields from "Enter Financial" which then update my financial fields in the portal. No problem there...EXCEPT a calculation(calc discount) that is supposed to update a field called "discount" which doesn't work.

However, if I create a layout with Financial as my primary table, and enter data into the fields, the calculation works fine, and updates the "discount" field in my financial table. Any suggestions would be greatly appreciated. Thanks in advance!

[Søren Dyhr]

It looks as if your discount is based on a summary fields and not a Sum( over the relation?

Best way to get things solved, is to make a raw template only containing the bare necessities to show your problem.

--sd