Loading
Upcoming Mandatory Changes to Public Key Infrastructure (PKI)Read More
Salesforce Enforces New Security Requirements in Summer 2026Read More
Decision Table
Create a Decision Table to Determine Order Discount Percentage (Example)

Create a Decision Table to Determine Order Discount Percentage (Example)

After you create the custom object that contains the business rules, you can create the decision table. In this example, you use a decision table to determine order discount percentages.

Required Editions

Available in: Lightning Experience
Available in: Enterprise, Performance, and Unlimited Editions with Loyalty Management or Rebate Management
User Permissions Needed
To create, edit, and activate a decision table: System Administrator profile
Note
Note Decision tables are also available as part of Business Rules Engine. If your org has Business Rules Engine enabled, see Decision Tables for Business Rules Engine.

The decision table determines product discount percentages based on the rules defined in the Product Discount Rules custom object. The decision table populates the discount percentage for products in the Product standard object’s Discount field.

  1. From Setup, in the Quick Find box, enter Decision Tables, and then select Decision Tables.
  2. Click New.
  3. Provide these details, and then click Next.
    Field Value
    Name Decide Discount Percentage for Orders
    API Name Decide_Discount_Percentage_for_Orders
    Source Object Order Discount Rule
    First window while creating a Decision Table.
  4. Select the input fields, the output field, and then click Next.
    Field Name Use Operator
    Discount Output -
    Maximum Quantity Input Less or Equal
    Minimum Quantity Input Greater or Equal
    Product Name Input Equals
    Second window while creating a Decision Table.
  5. Click Next.
  6. Specify these details.
    Field Value
    Input Field Condition Custom Logic
    Custom Logic (1 AND 2) OR 3
    Custom logic
  7. Save your work.

Next, set up a dataset link that determines which records the decision table processes and provides outcomes for.

 
Loading
Salesforce Help | Article