Multi-Row Formula Tool
Use Multi-Row Formula to take the concept of the Formula tool a step further. This tool allows you to utilize row data as part of the formula creation and is useful for parsing complex data, and creating running totals, averages, percentages and other mathematical calculations.
The Multi-Row Formula tool can only update one field per tool instance. If you would like to update multiple fields, a Multi-Row Formula tool must be added to your workflow for each field to be updated.
Configure the Tool
- Choose to Update Existing Field or Create New Field. If creating a new field, enter a name, and select the Type and Size.
- Use Num Rows to set the row variables that display as in the expression editor. When set to 1, these variables display
- Row - 1: The row before the active row.
- Row + 0: This is the Active Row. The active row is where the result goes into.
- Row + 1: The row after the active row.
- When the Active row is the first row, you need to specify the Values for Rows that don't exist.
- Null: Null values are applied to nonexistent rows.
- 0 or Empty: The values are set to 0 or left empty (default).
- Set to Values of Closest Valid Row: The values of the closest valid row are set to the nonexistent rows.
- Group by (Optional): Either select fields individually or use the All or Clear buttons.
- Build the expression that will update the chosen field. See Expression Editor.
Because this tool includes an expression editor, an additional input anchor displays when the tool is used in an app or macro workflow. Use the Interface tools to connect to a Question anchor. See Interface Tools.