Cross-Workflow Calculations

Learn how to create calculations based on Fields that are in other Workflows

When you create a calculation expression in one Workflow, you might want to use data collected in other Workflows as inputs. Cross-Workflow calculations let you build complex calculation expressions with Fields from other Workflows. 

After creating your Calculation Field, enter your the Calculation Expression using %f as a Field placeholder and the appropriate operator. Then, using the search bar under Field Input, select the Workflow that has the appropriate Field. You can select the Workflow you are currently in, or can select a directly linked Workflow. 

When you select a Field from a Linked Workflow, you will be also asked to select an Operation. Operations help you set how you want your data aggregated on your Record if a Record on your current Workflow has many linked Records in your selected Workflow.

You have the option to use:

1. Newest: The most recent Field value from all the Records in the Linked Workflow

2. Oldest: The oldest Field value from all the Records in the Linked Workflow

3. Sum: The sum of all the Field values from all the Records in the Linked Workflow

4. Average: The average of all the Field values from all the Records in the Linked Workflow

5. Highest: The highest Field value from all the Records in the Linked Workflow. 

6. Lowest: The lowest Field value from all the Records in the Linked Workflow.

For more information on calculations, visit Creating Advanced Calculations.