Formula
You can use this step to create a column as a formula based on other columns. A column can be referenced by its name without quotes or any other escaping character.
Warning: we do not support column names including whitespaces at the moment.
So please apply a rename step beforehand if needed. (For example rename
my column
into my_column
)
You can also specify a text escaped by quotes. It will then write the specified text in every row of the new column.
This step is supported by the following backends:
 Mongo 4.0
 Mongo 3.6
Where to find this step?
 Widget
Add
andCompute
 Search bar
Options reference

Formula
: the formula, which can be an algebraic formula composed of numbers, maths operators and columns; it can also be a text (escaped by quotes) to uniformly fill the column with that text. 
New column
: the name of the new column to be created with the formula result.
Example
This configuration results in:
 Previous
 Next