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.
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.