Loading
Sales Performance Management
Table of Contents
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

          Search all of Salesforce Help
          Create a Lump-Sum Rule

          Create a Lump-Sum Rule

          For lump-sum rules, the final payout calculation comes from a single cell in a worksheet. Worksheets contain formulas that have a single value, either entered directly or as the result of a formula. The result of 2 + 2 is 4, a single value. We don't calculate data for every record in the data filter that’s used.

          Required Editions

          Available in: both Salesforce Classic (not available in all orgs) and Lightning Experience
          Available in: Enterprise, Unlimited, and Developer Editions
          Available for an additional cost in: Professional Edition with Web Services API Enabled
          User Permissions Needed
          To create a lump-sum rule:

          A Spiff user role with these permissions turned on.

          • Designer Configuration: Manage
          • Quotas: Edit
          1. Create a folder for the rule.
            1. In Designer, click the three dots next to the plan you’re creating the rule for, and click New Folder.
            2. Rename the rule folder.
          2. Create a quota table.
            1. Click the three dots next to the rule folder and select New Quota Table.
            2. Set up the quota table with reps, quotas, and change periods.
          3. Create a worksheet in the rule folder.
            1. Click the three dots next to the rule folder and select New Worksheet.
            2. Set up the worksheet with labeled columns and functions, attainment, and commission fields,.
            Worksheet showing values for a lump-sum rule
          4. Add the new rule as a payout rule.
            1. Click a plan in the left panel and click New Payout Rule.
            2. Name the rule and select the commission calculation field as the payout amount.

          After creating a lump-sum rule, calculate it.

           
          Loading
          Salesforce Help | Article