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 |