Multi-Sheet Decision Tables allow you to take complex business requirements and break them down into constituent sets of business rules. It does this by allowing you to have multiple decision sheets with the formula. This can useful for both making your Decision Table logic more readable as well as separation of different entitlement criteria.

For this article it is assumed that you have at least basic familiarity with Decision Tables and/or have read the following articles:

Note: We will not detail step-by-step instructions here on how to set up Conditions or Actions, please read the above articles if you need detailed configuration steps.

Setting up a Multi-Sheet Decision Table

To create a Multi-Sheet Decision Table you click on Commands and then on Toggle Editor as you would for a standard Decision Table.

This will open up the standard Decision Table canvas.

As you can see from the above screenshot you now have 3 sheets on the Decision Table.

  • Decision Table
  • Calculations
  • Actions

Right-click on the Decision Table and the Context-Menu will popup, from this select Insert > Insert Decision Table

This will add a second Decision Sheet.

This is now a Multiple-Sheet Decision Table.

Renaming Sheets

To rename a Decision Sheet double click on the sheet name.

The text will become editable and you can enter the new name for the sheet.

Once the sheet is renamed just click off the field and the sheet name will be changed to the new value. 

Decision Table Calculations

Each Sheet in the Multi-Sheet Decision Table can generate results and these may need to be accessed from other Sheets.
These will show up under the Decision Table Calculations node on the Source tab of the configuration pane.

These are separate and distinct from regular Calculations.

How to set up Decision Table Calculations

  • Name your Action something meaningful
  • Right-click on the Decision Table and select  Operations Toggle Advanced Mode
  • Row 3 will appear on the Decision Table Sheet
  • In the cell below the Action Name type in "=="
  • This will mark this Action as a Decision Table Calculation
  • This Action Name will now appear in the Decision Table Calculations node of the Source tab

In the example below we are marking Discount % as a Decision Table Calculation

This Decision Table Calculation is now available to be used in other Decision Table Sheets.

Copying Entire Decision Table Sheets

It is possible to copy an entire Decision Table Sheet within the same Multi-Sheet Decision Table.

To do this:

  • Right-Click on the Decision Table Sheet to bring up the context-menu
  • Hold down the CTRL key on your keyboard and click on  Cells Copy from the context-menu
  • The entire Decision Table Sheet will be duplicated