Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

SUM multiple calculations in one field.

Topic Labels: Community Formulas
Solved
Jump to Solution
840 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.