For Calculated Measures, Flow provides a number of built-in functions similar to what you would find in standard spreadsheet applications. In addition to the built-in functions, Flow allows you to create your own User Defined Functions.
Built-in Functions
Flow includes the following built-in functions:
Sum:
Returns the sum of a range of numbers.
| Parameter | Description |
| values | A comma separated list of values or an array of values |
Average:
Returns the average of a range of numbers.
| Parameter | Description |
| values | A comma separated list of values or an array of values |
Min:
Returns the smaller of a range of numbers.
| Parameter | Description |
| values | A comma separated list of values or an array of values |
Max:
Returns the largest of a range of numbers.
| Parameter | Description |
| values | A comma separated list of values or an array of values |
Floor:
Returns the largest integer less than or equal to the specified number.
| Parameter | Description |
| value | A double-precision floating-point value |
Ceiling:
Returns the smallest integer value that is greater than or equal to the specified number.
| Parameter | Description |
| value | A double-precision floating-point value |
Round:
Rounds a value to the nearest integer or to the specified number of fractional digits.
| Parameter | Description |
| value | A double-precision floating-point value |
| digits | (Optional) Number of fractional digits to round the value to |
Truncate:
Calculates the integer part of a specified number.
| Parameter | Description |
| value | A double-precision floating-point value |
Sqrt:
Returns the square root of a specified number.
| Parameter | Description |
| value | A double-precision floating-point value |
Pow:
Returns a specified number raised to the specified power.
| Parameter | Description |
| value | A double-precision floating-point value |
| power | The power to raise the value to |
Remainder:
Returns the remainder resulting from the division of a specified number by another specified number.
| Parameter | Description |
| value1 | A double-precision floating-point value |
| value2 | A double-precision floating-point value |
Abs:
Returns the absolute value of a number.
| Parameter | Description |
| value | A double-precision floating-point value |
PI:
Represents the ratio of the circumference of a circle to its diameter, specified by the constant, π.
Asin:
Returns the angle whose sine is the specified number.
| Parameter | Description |
| value | A double-precision floating-point value |
Acos:
Returns the angle whose cosine is the specified number.
| Parameter | Description |
| value | A double-precision floating-point value |
Atan:
Returns the angle whose tangent is the specified number.
| Parameter | Description |
| value | A double-precision floating-point value |
Atan2:
Returns the angle whose tangent is the quotient of two specified numbers.
| Parameter | Description |
| y | A double-precision floating-point value |
| x | A double-precision floating-point value |
Sin:
Returns the sine of the specified angle.
| Parameter | Description |
| angle | A double-precision floating-point value |
Cos:
Returns the cosine of the specified angle.
| Parameter | Description |
| angle | A double-precision floating-point value |
Tan:
Returns the tangent of the specified angle.
| Parameter | Description |
| angle | A double-precision floating-point value |
Sinh:
Returns the hyperbolic sine of the specified angle.
| Parameter | Description |
| angle | A double-precision floating-point value |
Cosh:
Returns the hyperbolic cosine of the specified angle.
| Parameter | Description |
| angle | A double-precision floating-point value |
Tanh:
Returns the hyperbolic tangent of the specified angle.
| Parameter | Description |
| angle | A double-precision floating-point value |
e:
Represents the natural logarithmic base, specified by the constant, e.
Exp:
Returns e raised to the specified power.
| Parameter | Description |
| power | A double-precision floating-point value |
Log:
Returns logarithm of a specified number in the natural (base e) or to the specified base.
| Parameter | Description |
| value | A double-precision floating-point value |
| base | (Optional) Numeric base of the logarithm to use |
Log10:
Returns the base 10 logarithm of a specified number.
| Parameter | Description |
| value | A double-precision floating-point value |
If:
Conditional if statement that returns the first number if a condition is true otherwise return the second number.
| Parameter | Description |
| condition | A Boolean (true/false) value that determines which number to return |
| trueValue | A double-precision floating-point value to return if condition is true |
| falseValue | A double-precision floating-point value to return if condition is false |
IfNull:
Conditional if statement that returns the first number if it is not equal to null otherwise return the second number.
| Parameter | Description |
| value | A double-precision floating-point value |
| defaultValue | A double-precision floating-point value to return if value parameter is equal to null |
And:
Returns true if all of the conditions specified are true.
| Parameter | Description |
| conditions | A comma separated list of conditions or an array of conditions |
Or:
Returns true if any of the conditions specified are true.
| Parameter | Description |
| conditions | A comma separated list of conditions or an array of conditions |
XOr:
Returns true if an odd number of the conditions specified are true.
| Parameter | Description |
| conditions | A comma separated list of conditions or an array of conditions |
Not:
Returns true if the condition specified is false.
| Parameter | Description |
| conditions | A Boolean value |