---
schema_version: "1"
id: 0bf38e2081263d677d631e0d3535fd9704604dff15d073cc49673f14fd773853
title: Understand How Outcome Sorting Works
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/ind/264-0-0/concept_decision_table_sort_order.md
canonical_url: https://help.salesforce.com/s/articleView?id=ind.concept_decision_table_sort_order.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 7fcc1791656ff4e89ad21ff14f64a175e088ee6a7a0a6d61eccbe38e2b576d47
description: When creating a decision table, you can specify a sort order for the outcomes based on the values of either an input or an output sort by field. Outcomes are finally sorted based on the value of the sort by field in the outcome’s record and the sort order.
products:
  - Industry Solutions
  - Cross Cloud
release: "264"
---
# Understand How Outcome Sorting Works

When creating a decision table, you can specify a sort order for the outcomes based on the values of either an input or an output sort by field. Outcomes are finally sorted based on the value of the sort by field in the outcome’s record and the sort order.

### 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: Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: Enterprise, Performance, and Unlimited Editions with Loyalty Management or Rebate Management</td></tr></tbody></table>

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-ind-decision_table-264-0-0-production-enus/b36b081a-a35e-4748-bca9-059568605a0b/images/icon_note.png)

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](https://help.salesforce.com/s/articleView?id=ind.decision_tables.htm&type=5&language=en_US).

You can use these sort orders to sort outcomes:

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
      <colgroup>
        <col style="width:33.33333333333333%">
        <col style="width:33.33333333333333%">
        <col style="width:33.33333333333333%">
      </colgroup>
      <thead class="slds-text-title_caps ">
        <tr class="">
          <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d4167e70">Sort Order</th>
          <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d4167e73">Description</th>
          <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d4167e76">Example</th>
        </tr>
      </thead>
      <tbody>
        <tr class="">
          <td data-label="Sort Order" class="slds-cell-wrap" style="vertical-align:top;" headers="d4167e70 ">Ascending with Blank Value First</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d4167e73 ">The decision table checks the values of the selected sort by field in the outcome
            records and provides the outcomes in the ascending order. The outcome that doesn’t contain a
            value for the sort by field in one of the outcome records is provided first.</td>

          <td data-label="Example" class="slds-cell-wrap" style="vertical-align:top;" headers="d4167e76 ">
            <ul>
              <li>Numerical: 5, 2.5, 10, 15, 20</li>

              <li>Text: Delhi, Adelaide, California, London, Naples</li>

            </ul>
            <p style="margin-bottom:0;">The records that provided 5 and Delhi as the outcomes don’t contain a value for the sort
              by field.</p>
          </td>

        </tr>
        <tr class="">
          <td data-label="Sort Order" class="slds-cell-wrap" style="vertical-align:top;" headers="d4167e70 ">Ascending with Blank Value Last</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d4167e73 ">The decision table checks the values of the selected sort by field in the outcome
            records and provides the outcomes in the ascending order. If the field doesn’t have a value
            in any one of the outcome records, then that outcome is provided last.</td>

          <td data-label="Example" class="slds-cell-wrap" style="vertical-align:top;" headers="d4167e76 ">
            <ul>
              <li>Numerical: 2.5, 10, 15, 20, 5</li>

              <li>Text: Adelaide, California, London, Naples, Delhi</li>

            </ul>
            <p style="margin-bottom:0;">The records that provided 5 and Delhi as the outcomes don’t contain a value for the sort
              by field.</p>
          </td>

        </tr>
        <tr class="">
          <td data-label="Sort Order" class="slds-cell-wrap" style="vertical-align:top;" headers="d4167e70 ">Descending with Blank Value First</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d4167e73 ">The decision table checks the values of the selected sort by field in the outcome
            records and provides the outcomes in the ascending order. If the field doesn’t have a value
            in any one of the outcome records, then that outcome is provided last.</td>

          <td data-label="Example" class="slds-cell-wrap" style="vertical-align:top;" headers="d4167e76 ">
            <ul>
              <li>Numerical: 5, 20, 15, 10, 5, 2.5</li>

              <li>Text: Delhi, Naples, London, California, Adelaide</li>

            </ul>
            <p style="margin-bottom:0;">The records that provided 15 and Delhi as the outcomes don’t contain a value for the sort
              by field.</p>
          </td>

        </tr>
        <tr class="">
          <td data-label="Sort Order" class="slds-cell-wrap" style="vertical-align:top;" headers="d4167e70 ">Descending with Blank Value Last</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d4167e73 ">The decision table checks the values of the selected sort by field in the outcome
            records and provides the outcomes in the ascending order. If the field doesn’t have a value
            in any one of the outcome records, then that outcome is provided last.</td>

          <td data-label="Example" class="slds-cell-wrap" style="vertical-align:top;" headers="d4167e76 ">
            <ul>
              <li>Numerical: 20, 15, 10, 5, 2.5, 5</li>

              <li>Text: Naples, London, California, Adelaide, Delhi</li>

            </ul>
            <p style="margin-bottom:0;">The records that provided 5 and Delhi as the outcomes don’t contain a value for the sort
              by field.</p>
          </td>

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

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-ind-decision_table-264-0-0-production-enus/b36b081a-a35e-4748-bca9-059568605a0b/images/icon_note.png)

Note Outputs can’t be sorted based on picklist and multi-select picklist fields.