Follow

What "Functions" Are Available In Flow?

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. 

Toolbox-Functions.png

 

Built-in Functions

Toolbox-Functions-AllBuiltInFunctions.png

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
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments