DATA Calculate function

The DATA Calculate function in RPA.

Help CentreFunctions & Formulas

This article describes the RPA Data functionality to calculate.

For a full list of available functions, please read DATA functions.


Description

The DATA Calculate function allows you to calculate.


Setting it up

To use the DATA Calculate function, follow these instructions:

{{popups:rpas/add:action=calculate}}

Once on a process map:

  1. Navigate to the process where you would like to add the DATA Calculate function
  2. Click on the green button’s drop-down (right side of the green button labelled “Process”)
  3. On the menu that appears, click on the “+ Activity” item
  4. From here you can select the DATA Calculate option
  5. Click "Add" once you are done

Input parameters

ParameterRequiredTypeDefaultDescription
Variable / Formula pairsYesKey-ValuePairs of variable names and the formula to calculate their value.

Output variables

VariableTypeDescription
VariablesVariousEach variable is set to the result of its formula.

Errors

ErrorDescription
Formula errorThe formula contains a syntax error or invalid reference.

Tips

  • Supports all CALC functions (e.g. SUM, IF, ROUND, CONCAT). See the calculation functions help article.
  • Use {variable_name} syntax to reference other variables in formulas.

Related functions

See it working on your own data

Everything documented here ships with the platform – try the document tools free, or go live in 7 days.