Category: Automation Calculation Actions

The Create a Decimal Calculation Action Builder will perform a designate calculation and return a decimal value.

Enter in the calculation and click Next.

Values can be passed into Calculation by creating a parameter.

By enclosing a value in [ ] brackets, that flags the word as a parameter. The name of the parameter, in the picture, would be statename.

Parameters will have the value substituted during the script execution.

If parameters are found in the Calculation, they wil be listed in the Name drop down.

Name – the name of the parameter within the criteria.

Type – type of value to be expected (String, Bool, Date, Decimal, Number).

Variable – the variable that will hold the value. The drop down will contain existing variables or type in a new variable name.

Click the Add button to add the parameter name and value to be substituted.

Add Text Calc Parameter – maps a Calculation Parameter to a value to be substituted.

Decimal Calculation – performs a calculation and returns a Decimal value.

Note: all Parameter variables will need to be set prior to this portion of the script.

The Create a Number Calculation Action Builder will perform a designate calculation and return a number value.

Enter in the calculation and click Next.

Values can be passed into Calculation by creating a parameter.

By enclosing a value in [ ] brackets, that flags the word as a parameter. The name of the parameter, in the picture, would be statename.

Parameters will have the value substituted during the script execution.

If parameters are found in the Calculation, they wil be listed in the Name drop down.

Name – the name of the parameter within the criteria.

Type – type of value to be expected (String, Bool, Date, Decimal, Number).

Variable – the variable that will hold the value. The drop down will contain existing variables or type in a new variable name.

Click the Add button to add the parameter name and value to be substituted.

Add Text Calc Parameter – maps a Calculation Parameter to a value to be substituted.

Number Calculation – performs a calculation and returns a Number value.

Note: all Parameter variables will need to be set prior to this portion of the script.

The Create a Date Calculation Action Builder will perform a designate calculation and return a date value.

Enter in the calculation and click Next.

Values can be passed into Calculation by creating a parameter.

By enclosing a value in [ ] brackets, that flags the word as a parameter. The name of the parameter, in the picture, would be statename.

Parameters will have the value substituted during the script execution.

If parameters are found in the Calculation, they wil be listed in the Name drop down.

Name – the name of the parameter within the criteria.

Type – type of value to be expected (String, Bool, Date, Decimal, Number).

Variable – the variable that will hold the value. The drop down will contain existing variables or type in a new variable name.

Click the Add button to add the parameter name and value to be substituted.

Add Text Calc Parameter – maps a Calculation Parameter to a value to be substituted.

Date Calculation – performs a calculation and returns a Date/Time value.

Note: all Parameter variables will need to be set prior to this portion of the script.

The Create a Bool Calculation Action Builder will perform a designate calculation and return a bool (True or False) value.

Enter in the calculation and click Next.

Values can be passed into Calculation by creating a parameter.

By enclosing a value in [ ] brackets, that flags the word as a parameter. The name of the parameter, in the picture, would be statename.

Parameters will have the value substituted during the script execution.

If parameters are found in the Calculation, they wil be listed in the Name drop down.

Name – the name of the parameter within the criteria.

Type – type of value to be expected (String, Bool, Date, Decimal, Number).

Variable – the variable that will hold the value. The drop down will contain existing variables or type in a new variable name.

Click the Add button to add the parameter name and value to be substituted.

Add Text Calc Parameter – maps a Calculation Parameter to a value to be substituted.

Bool Calculation – performs a calculation and returns a Bool (True and False) value.

Note: all Parameter variables will need to be set prior to this portion of the script.

The Create a Text Calculation Action Builder will perform a designate calculation and return a text value.

Enter in the calculation and click Next.

Values can be passed into Calculation by creating a parameter.

By enclosing a value in [ ] brackets, that flags the word as a parameter. The name of the parameter, in the picture, would be statename.

Parameters will have the value substituted during the script execution.

If parameters are found in the Calculation, they wil be listed in the Name drop down.

Name – the name of the parameter within the criteria.

Type – type of value to be expected (String, Bool, Date, Decimal, Number).

Variable – the variable that will hold the value. The drop down will contain existing variables or type in a new variable name.

Click the Add button to add the parameter name and value to be substituted.

Add Text Calc Parameter – maps a Calculation Parameter to a value to be substituted.

Text Calculation – performs a calculation and returns a Text (String) value.

Note: all Parameter variables will need to be set prior to this portion of the script.

Action Builders are step by step wizards that help you build scripts quickly.

Click on the Action Builder and the Action Builder Wizard will pop up.

Maps a Decimal value to a parameter and adds it to a Parameter List.

The Parameter List will be part of the input to the calculation.

Parameters – the Parameter List this will be added too.

Name – name of the parameter. For example, the parameter [statename] will have the name of statename.

Value – the value or variable that will be substituted within the calculation.

Maps a Number value to a parameter and adds it to a Parameter List.

The Parameter List will be part of the input to the calculation.

Parameters – the Parameter List this will be added too.

Name – name of the parameter. For example, the parameter [statename] will have the name of statename.

Value – the value or variable that will be substituted within the calculation.

Maps a Date/Time value to a parameter and adds it to a Parameter List.

The Parameter List will be part of the input to the calculation.

Parameters – the Parameter List this will be added too.

Name – name of the parameter. For example, the parameter [statename] will have the name of statename.

Value – the value or variable that will be substituted within the calculation.

Maps a bool (True or False) value to a parameter and adds it to a Parameter List.

The Parameter List will be part of the input to the calculation.

Parameters – the Parameter List this will be added too.

Name – name of the parameter. For example, the parameter [statename] will have the name of statename.

Value – the value or variable that will be substituted within the calculation.