Help

Salesperson Commission Formula

Topic Labels: Formulas
Solved
Jump to Solution
1447 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Lynn_Wood
4 - Data Explorer
4 - Data Explorer

I am trying to build a table for my husband’s business that will show the commission earned for each of his employees. He has a column for Grand Total of Sale, Salesperson Commission %, and Salesperson $. He would put in the Grand Total and the Salesperson commission percent but needs the Salesperson $ field to populate. I know this is a very easy formula for all of you but I am obviously new to this. Thank you in advance for all your help.

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

Welcome to the Airtable community!

Assuming that your grand total is a currency field and the commisison percent is a percent field, you can create a formula field that multiplies the two numbers …

{Grand Total of Sale} * {Salesperson Commission %}

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

Welcome to the Airtable community!

Assuming that your grand total is a currency field and the commisison percent is a percent field, you can create a formula field that multiplies the two numbers …

{Grand Total of Sale} * {Salesperson Commission %}
Lynn_Wood
4 - Data Explorer
4 - Data Explorer

Thank you. That worked great. I knew it had to be a simple solution.