Simple math transform functions
Summarize
Summary of Simple math transform functions
Simple math transform functions in ServiceNow Yokohama release enable you to perform basic mathematical calculations on Number data pills. These functions require input data pills of type Array.Number, Array.Integer, or Array.Decimal. Using the correct input type is crucial, as applying a function to an incompatible data type returns the original input without transformation during runtime.
Show less
Key Functions and Their Use
- Absolute Value: Returns the non-negative distance of a number from zero.
- Add: Adds a specified value to the input number.
- Average: Calculates the average value of elements in an input array.
- Count: Counts the number of elements in an input array of various data types.
- Divide: Divides the input number by a specified value.
- Max: Finds the highest value in an input number array.
- Median: Finds the median value within an input number array.
- Min: Finds the lowest value in an input number array.
- Multiply: Multiplies the input number by a specified value.
- Power: Raises the input number to the power of a specified exponent.
- Round: Rounds the input number to a specified digit position based on standard rounding rules.
- Square Root: Computes the positive square root of a positive input number.
- Subtract: Subtracts a specified value from the input number.
- Sum: Calculates the sum of elements in an input number array.
- To Fixed: Truncates a decimal number to a specified number of decimal places without rounding.
Practical Considerations
Ensure the input data pill types match the function requirements to avoid no-operation results. Parameters such as the number to add, subtract, multiply, divide, or the number of decimal places to truncate are critical for precise transformations. The functions handle arrays and single numeric inputs appropriately, returning numeric outputs that can be used in further flow processing.
Outcome
By leveraging these simple math transform functions in ServiceNow flows, you can automate numerical calculations, aggregate data, and manipulate numeric values efficiently within your workflows. This enables streamlined data processing and reduces the need for custom scripting for common mathematical operations.
Use simple math transform functions to perform basic mathematical calculations on Number data pills.
Simple math transform functions require an Array.Number, Array.Integer, or Array.Decimal input data pill. Make sure to use the correct input data pill type when applying simple math transform functions. If a simple math transform function is applied to an improper data type, the data is not transformed at runtime and the input value is returned instead. For more information on confirming your flow runtime values, see Test a flow.
Absolute Value
A mathematical function that returns the distance from zero for any real number. An absolute value is always a positive or zero value.
| Input data pill | Output data pill |
|---|---|
| Number, Integer, or Decimal | Number as the absolute value of the input number |
- Input:
-3 - Output:
3
Add
Adds the given value to the input.
| Input data pill | Parameters | Output data pill |
|---|---|---|
| Number, Integer, or Decimal | Number to be added. | Number as the addition of the input value by the parameter. |
- Input:
12 - Parameter:
4 - Output:
16
Average
Returns the average value of the elements in the input array.
| Input data pill | Output data pill |
|---|---|
| Array.Number, Array.Integer, or Array.Decimal | Number as the average value of the input array. |
- Input:
[10, 30, 20] - Output:
20
Count
Returns the number of elements in the input array.
| Input data pill | Output data pill |
|---|---|
| Array.Number, Array.Integer, Array.Decimal, Array.Object, Array.String, or Array.Boolean | Number of elements in the input array |
- Input:
[2, 10, 30] - Output:
3
Divide
Divides the input value by a given value.
| Input data pill | Parameters | Output data pill |
|---|---|---|
| Number, Integer, or Decimal | Number to divide the input value by. | Number as the division of the input value by the parameter. |
- Input:
12 - Parameter:
4 - Output:
3
Max
Returns the highest value found in the input Array.
| Input data pill | Output data pill |
|---|---|
| Array.Number, Array.Integer, or Array.Decimal | Number as the highest value in the input Array |
- Input:
[1, -5, 20, 6] - Output:
20
Median
Returns the median value of elements in the input array.
| Input data pill | Output data pill |
|---|---|
| Array.Number, Array.Integer, or Array.Decimal | Number as the median value of the input array. |
- Input:
[10, 30, 15] - Output:
15
Min
Returns the lowest value found in the input Array.
| Input data pill | Output data pill |
|---|---|
| Array.Number, Array.Integer, or Array.Decimal | Number as the lowest value in the input Array |
- Input:
[1, -5, 20, 6] - Output:
-5
Multiply
Multiplies the input value by a given value.
| Input data pill | Parameters | Output data pill |
|---|---|---|
| Number, Integer, or Decimal | Number to be multiplied. | Number as multiplication of the input value by the parameter. |
- Input:
12 - Parameter:
4 - Output:
48
Power
Returns the value of the input value raised to the power of a given value.
| Input data pill | Parameters | Output data pill |
|---|---|---|
| Number, Integer, or Decimal | Number as the exponent of the power. | Number as the power of input value to the parameter. |
- Input:
2 - Parameter:
3 - Output:
8
Round
A mathematical function that approximates a numeric value based on rounding rules and a digit position. The function rounds up by adding one to the digit to be rounded and then replacing all digits to its right with zeroes.
| Input data pill | Parameters | Output data pill |
|---|---|---|
| Number, Integer, or Decimal | Number of Digits - A positive integer specifying the position of the digit to be rounded starting on the left | Number as the rounded value of the input number |
- Input:
194 - Parameter:
2 - Output:
190
Square Root
A mathematical function that computes a positive number that when multiplied by itself produces the input value. The input value must be a positive real number.
| Input data pill | Output data pill |
|---|---|
| Number, Integer, or Decimal | Number as the square root of the input number |
- Input:
16 - Output:
4
Subtract
Subtracts the given value from the input.
| Input data pill | Parameters | Output data pill |
|---|---|---|
| Number, Integer, or Decimal | Number to subtract from the input value. | Number as the subtraction of the input value by the parameter. |
- Input:
12 - Parameter:
4 - Output:
8
Sum
Returns the sum of all values in the input Array.
| Input data pill | Output data pill |
|---|---|
| Array.Number, Array.Integer, or Array.Decimal | Number as a sum of all values in the input Array |
- Input:
[1, -5, 20, 6] - Output:
22
To Fixed
Truncates a floating number to the specified number of decimal places.
| Input data pill | Parameter | Output data pill |
|---|---|---|
| Number - Decimal number before truncation. | Number of Digits - Number that specifies the number of decimal places to truncate. | Number - Decimal number after truncation. |
- Input:
1.93456 - Parameter:
2 - Output:
1.93