---
schema_version: "1"
id: ef78c236f4491c36d39fce1b442447446b9fc9fed1b18e495d7fbe66d96e722f
title: Sample Commission Calculations Formulas
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/platform/264-0-0/useful_advanced_formulas_commission.md
canonical_url: https://help.salesforce.com/s/articleView?id=platform.useful_advanced_formulas_commission.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 9e1ba8a7c105c1aded7a16670e84651a9921c0f47063ddcc9cb88209876997ef
description: Calculate commissions, assign rates by deal size, identify commissions that meet a threshold, and return the highest asset commission.
products:
  - Salesforce Platform
  - Security
release: "264"
---
# Sample Commission Calculations Formulas

Calculate commissions, assign rates by deal size, identify commissions that meet a threshold, and return the highest asset commission.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: both Salesforce Classic and Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Essentials</strong>, <strong>Group</strong>, <strong>Professional</strong>, <strong>Enterprise</strong>, <strong>Performance</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions</td></tr></tbody></table>

For details about using the functions included in these samples, see [Formula Operators and Functions](https://help.salesforce.com/s/articleView?id=platform.customize_functions.htm&release=264.0.0&type=5 "Use these operators and functions when building formulas. All functions are available everywhere that you can include a formula, such as formula fields, validation rules, approval processes, and workflow rules, unless otherwise specified.").

## Commission Amounts for Opportunities

The following is a simple formula where commission is based on a flat 2% of the opportunity Amount.

```
IF(ISPICKVAL(StageName, "Closed Won"), 
  ROUND(Amount *0.02, 2), 0)
```

This example calculates the commission amount for any opportunity that has a “Closed Won” stage. The value of this field is the amount times 0.02 for any closed or won opportunity. Open or lost opportunities have a zero commission value.

## Commission Deal Size

This formula calculates a commission rate based on deal size, returning a 9% commission rate for deals over 100,000 and an 8% commission rate for smaller deals.

```
IF(Amount > 100000, 0.09, 0.08 )
```

## Commission Greater Than or Equal To

This formula assigns the YES value with a commission greater than or equal to one million. Note, this field is a text formula field that uses a custom currency field called Commission.

```
IF(Commission__c >=
                    1000000, "YES", "NO")
```

## Commission Maximum

This formula determines what commission to log for an asset based on which is greater: the user's commission percentage of the price, the price times the discount percent stored for the account or 100 dollars. This example assumes you have two custom percent fields on users and assets.

```
MAX($User.Commission_Percent__c * Price,
  ​Price * Account_Discount__c, 100)
```