Help

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: 
gabumstead
4 - Data Explorer
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
Ella
7 - App Architect
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.

See Solution in Thread

1 Reply 1
Ella
7 - App Architect
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.