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.
Solved
Salesperson Commission Formula
Best answer by kuovonne
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 %}
+29Welcome 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 %}
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.