Is there a way to lock the result of a calucation.
I give a simplified example.
in one table I have total project budgets.
project a 10.000
proejct b 20.000
in other table i have invoiced amounts
invoice 1 / project a / 10% / 1.000
invoice 2 / project b / 20% / 4.000
invoice 3 / project a / 25% / 2.500
Now when a project budget changes (for example project A changes to 15.000 euro).
I don’t want the calculated amounts in the second table to change (last column)
My document is a lot more complex, but this is the essence of what I need to accomplish.