SUM multiple calculations in one field.

[gabumstead]

Here's what I want to do. I have a field that lists percentages for the fees my company wants to add to a contract. Admin fee 10%, Late fee 5%, etc. If I were to stack these fees, I want to have a field that returns the sum of each percentage multiplied by the contract subtotal field. Is there any way to do this? 

Like: SUM ( (10% x $800), (5% x $800) ) but where it could recognize the array and do the math for each percentage. 

[Ella · Accepted solution]

Hi @gabumstead ,

I am a little confused about what exactly you want the end result to look like.

However, a formula field would calculate the percentage x fee and then you could have a rollup field in a summary table (i.e. you would have 1 table for each fee and another table for the total for each client) to get the total for each client.