Use a math functionFunctions you can use in Boost.space Integrator - create, update, delete, get, search. to apply mathematical operationsOperations are tasks in integration scenarios, similar to "operations" in Make.com. Each action, like reading or updating a record, counts as one operation. They’re essential for data syncing between apps and reset monthly. Going over the limit pauses syncing until you add more or upgrade your plan. to data. For example, math functionsFunctions you can use in Boost.space Integrator - create, update, delete, get, search. let you get an average of an arrayWithin a bundle, data items of the same type are sometimes in an array. You can find an array by looking at the details of a bundle. Depending on the details of your scenario, you can map other modules to a specific item in an array or use iterators and aggregators to manipulate your data into other formats. When mapping,..., round a value up or down, or change the format of a number (1 000 000 to 1,000,000 or 1.000.000). Below is a list of supported math functions and a brief description of each one.
Returns the average value of the numeric values in a specific array, or the average value of numerical values entered individually.
Returns the smallest integer greater than or equal to a specified number.
ceil( 1.2 )
= 2
ceil( 4 )
= 4
Returns the largest integer less than or equal to a specified number.
floor( 1.2 )
= 1
floor( 1.9 )
= 1
floor( 4 )
= 4
Returns a number in the requested format. Decimal point is `,` by default, Thousands separator is `.` by default.
formatNumber( 123456789 ; 3 ; , ; . )
= 123.456.789,000
Returns the largest number in a specified array, or the largest number among numbers entered individually.
Returns the smallest number in a specified array, or the smallest number among numbers entered individually.
Parses a string with a number and returns the number.
Example: parseNumber( 1 756,456 ; , )
Rounds a numeric value to the nearest integer.
round( 1.2 )
= 1
round( 1.5 )
= 2
round( 1.7 )
= 2
round( 2 )
= 2