Formula

Description

Formula is a step in the Scripting Plugin for Process Studio Workflows. The Formula step can calculate Formula Expressions within a data stream. It can be used to create simple calculations like [A]+[B] or more complex business logic with a lot of nested if / then logic. When you press on the Formula cell entry, the formula editor window opens and gives you help on the available functions: The formula editor window does a direct check on the syntax and the field names supplied. In case of an error you get the error message for the instance.

Configurations

No.	Field Name	Description
1	Step name	Name of the step as it appears in the workflow workspace. This name has to be unique in a single workflow.
	Fields:
1	Result Field	Specify the field name to hold the output result.
2	Formula	Build the Formula using available functions in the Formula editor. Click on the cell, the Formula Editor will open. In the left pane, the group of functions is available. In the right pane, the formula can be seen in the Expression field. A detailed explanation of the selected formula appears in the section under the Expression field.