Calculate

Create additional calculated columns

Perform calculations to add attributes to each entry the list

list[].attribute1
list[].attribute1
list[].attribute2
list[].attribute2
list[].attribute3
list[].attribute3

The Calculate building block allows you to perform calculations or conversions on existing values. Thereby create new columns for values you are interested in

Use cases

  • Calculate the total column by multiplying quantity and price

Configuration

Click on the bold text in the title of the building block to open the configuration dialog.

 After adding the script to your flow, click on the keyboard icon in the input parameter section.

row.amount = row.amount / 100; row.total = row.amount * row.quantity

Questions and Feedback

If you have any comments on this page, feel free to add suggestions right to the Google document that we are using to create this site.

If you are not yet member of the Ultradox community on Google+, please join now to get updates from our end or to provide feedback, bug reports or discuss with other users.

Last Updated: 11/27/17