The Global Calculation sheet is displayed when using the Decision Tables Advanced Mode. It allows the user to quickly add and edit Calculations that can be referenced by Decision Table sheets.
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.
Difference between a Global Action and a Global Calculation
A Global Action will only be executed when referenced elsewhere in the Decision Table.
A Global Calculation sheet will be executed at the start of the formula regardless of whether or not it is referenced.
Where to find Global Calculations
To show the Global Calculations sheet, open a Decision Table, right-click and select Operations > Toggle Advanced Mode
You will then see the Global Calculations sheet (along with other sheets like Global Actions and Global FetchXml)
How to setup Global Calculations
- In a cell in column A, give your Calculation a name.
- Then expand the Advanced Editor for the corresponding cell in column B
- Enter in your Calculation like below (in our example we are determining the date for someone's next birthday based on the current date)
- Collapse the Advanced Editor and click Save
- Add any other Calculations you may need
- Go to the Source tab and select the refresh icon
- Expand Global Calculation, you will see your new Calculation
- Now you will be able to reference this Calculation in any sheet
How to setup Global Calculation using a wizard
When you are using the function wizard in a Decision Table, you can give that function a friendly name and choose whether this reference is stored as a Global Action or a Global Calculation.
After selecting Generate, this function will be automatically added to the Global Actions or Global Calculations sheet depending on the Type selected.