---
schema_version: "1"
id: 8d24de774d9e8d6ffad97d2269b7f36bb004a9cb5b2d3af7f3cab3e103725d81
title: Add Emoji and Percentages to Attainment Bands
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/sales/264-0-0/spiff_statement_emoji_attainment.md
canonical_url: https://help.salesforce.com/s/articleView?id=sales.spiff_statement_emoji_attainment.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: b0934bc3dbf1191f522bc24e564215d8a6d96de6178b24d0ed17985c1645080c
description: Help reps interpret their performance at a glance when you add emoji and percentages to attainment-based displays.
products:
  - Sales Cloud
  - Sales Enablement
release: "264"
---
# Add Emoji and Percentages to Attainment Bands

Help reps interpret their performance at a glance when you add emoji and percentages to attainment-based displays.

### 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 (not available in all orgs) and Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Enterprise</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available for an additional cost in: <strong>Professional</strong> Edition with Web Services API Enabled</td></tr></tbody></table>

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d80795e78">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d80795e78 ">To create a range table and rule for attainment:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d80795e78 ">
              <p>A Spiff <a href="https://help.salesforce.com/s/articleView?id=sales.spiff_users_roles_and_permissions.htm&amp;release=264.0.0&amp;type=5" title="Give users the appropriate level of access so they can be successful in Salesforce Spiff, and enforce the principle of least privilege. Assign a default role to each user, or create custom roles with access to specific Spiff functionality.">user role</a> with these permissions turned on.</p>
              <ul>
                <li>Designer Configuration: Manage</li>

                <li>Designer Range Tables: Manage</li>

              </ul>
            </td>

          </tr>
        </tbody>
      </table>

1. Create a range table named EmojiAttainmentTable, where each range corresponds to a specific emoji that you want to show for a specific attainment level in commission statements.
    
    ![Attainment percentages and emoji](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sales-sales_performance_management-264-0-0-production-enus/b1f2feb4-26b8-444f-97f7-be2349869d93/sales_performance_management/images/spiff/spiff_emoji_attainment_table.png)
2. In the payout rule where you want to include the emoji based on attainment, include the `range_lookup` function, attainment calculation, and range table.
    
    In this example, the attainment calculation is MonthlyAttainment and the range table is EmojiAtainmentTable. The calculation dynamically inserts the appropriate emoji based on the attained value.
    
    ```
    range_lookup(MonthlyAttainment, EmojiAttainmentTable)
    ```
    
    ![Attainment calculation](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sales-sales_performance_management-264-0-0-production-enus/b1f2feb4-26b8-444f-97f7-be2349869d93/sales_performance_management/images/spiff/spiff_emoji_attainment_calculation.png)
3. Create a calculation that uses the `concat` function so the attainment and the emoji are on a metric card. Multiply the attainment calculation by 100 to get the correct percentage representation. Round the result to two decimal places. Add the % sign and append the attainment emoji calculation at the end of the string.
    
    ```
    concat([round(MonthlyAttainment * 100, 2), "%", AttainmentEmoji])
    ```
    
    ![Attainment calculation with concat function](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sales-sales_performance_management-264-0-0-production-enus/b1f2feb4-26b8-444f-97f7-be2349869d93/sales_performance_management/images/spiff/spiff_emoji_attainment_concat.png)