Hi Everyone., I hope you are well

I have a subform that has a "Total" Field that gets filled in on Load of the form.

I have a "profit" field that calculates "Total" less "Deductions" .

I have tried adding the formula for "Profit" on Load as wll but it is not working, I have added it on user input of the field " Total" and now it works.

My question is that I have a series of formulas for different fields that are ultimately determined by the "profit " field.

I was hiping to add them all on load instead of on "user input " as this creates a cacading effect.

Is this the most effective way to do it or is there a neater way to go about things?