Math Functions

To display the available math functions, expand the Math group in Formula Type.

Function

Description

Syntax

Sum

Sums all selected members.

Sum(...)

Ratio

Returns the ration between two members.

Parameter2/Parameter1

Growth

Returns the growth ratio.

(Parameter2-Parameter1)/Parameter1

Difference

Returns the difference between two members.

Parameter2-Parameter1

Average

Returns the average of selected members.

Average(...)

Max

Returns the maximum value for the selected members.

Max(...)

Min

Returns the minimum value for the selected members.

Min(...)

(...) = 2 or more parameters