#Calculation

The Calculation node can evaluate an expression, and the result is saved in the result of the corresponding node for use by subsequent nodes. It is a tool for calculating, processing, and transforming data. To some extent, it can replace the function in programming languages of calling a function on a value and assigning it to a variable.

#Create Node

In the workflow configuration interface, click the plus ("+") button in the flow to add a "Calculation" node:

#Node Configuration

#Calculation Engine

The calculation engine defines the syntax supported by the expression. The currently supported calculation engines are Math.js and Formula.js. Each engine has a large number of built-in common functions and methods for data operations. For specific usage, you can refer to their official documentation.

In addition, if you need simple string concatenation, you can directly use "String Template". This engine will replace the variables in the expression with their corresponding values and then return the concatenated string.

#Expression

An expression is a string representation of a calculation formula, which can consist of variables, constants, operators, and supported functions. You can use variables from the flow context, such as the result of a preceding node of the calculation node, or local variables of a loop.

If the expression input does not conform to the syntax, an error will be prompted in the node configuration. If a variable does not exist or the type does not match during execution, or if a non-existent function is used, the calculation node will terminate prematurely with an error status.

#Example

#Calculate Order Total Price

An order may contain multiple items, and each item has a different price and quantity. The total price of the order needs to be the sum of the products of the price and quantity of all items. After loading the list of order details (a one-to-many relationship dataset), you can use a calculation node to calculate the total price of the order:

Here, the SUMPRODUCT function from Formula.js can calculate the sum of products for two arrays of the same length, which yields the total price of the order.