# SUM multiple calculations in one field.

Topic Labels: Community Formulas
Solved
Jump to Solution
500 1
cancel
Showing results for
Search instead for
Did you mean:
4 - Data Explorer

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.

1 Solution

Accepted Solutions
7 - App Architect

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.

1 Reply 1
7 - App Architect

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.