To display the available custom functions, expand the Customized group in Formula Type.
|
Function |
Description |
Syntax |
|
% of Parent |
Returns member’s percentage of its ancestor. |
([Other Dimension].currentmember,Parameter1)/(Parameter1,Ancestor([Other Dimension].currentmember,1) |
|
% of Total |
Returns member’s percentage of dimension total. |
([Other Dimension].currentmember,Parameter1)/(Parameter1,Ancestor([Other Dimension].currentmember.[Other Dimension].[(All)]) |
|
Running Sum |
Returns the running sum of the selected members. |
Running sum for Parameter 1 |
|
Rank |
Ranks the selected member. |
|
In the following example, three customized formulas have been defined to analyze Dairy drinks in relation to the Drinks product category.
