Best way to handle complicated calculations

Best way to handle complicated calculations

HI All
We are looking to migrate a complicated financial application to an app using zoho creator.

There will be about 300 fields on 8 forms. each field contributes to a total calculation. so any time a field is updated it needs to call a function that updates a calculated field. Most of these calculated fields then also update a final calculation.

What we have done so far is to create a function that is called via a workflow on edit of each field.

If the function requires 10 fields then we must pass in 10 values as parameters to the function and from each of the 10 fields, call the function and pass in input values for all 10.

Is there an easier way to do what we are trying to accomplish here or is this the best way?


Thanks for any help