Excel Client:ElemChildIndex: Difference between revisions
From CoPlanner 10
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| Line 19: | Line 19: | ||
|Child-Element in the dimension, whose index should be returned | |Child-Element in the dimension, whose index should be returned | ||
|} | |} | ||
==Example== | ==Example== | ||
Revision as of 16:41, 14 April 2015
Function
ElemChildIndex(DimensionName, Parent, Child)
This function searches through the specified dimension and returns the index of the child element with refers to the parent element. If the child element is no sub-element of the specified parent element, the function returns -1.
| Parameter | Description |
| DimensionName | Name of the dimension |
| Parent | Parent-Element in the dimension, which should be the parent of the specified child |
| Child | Child-Element in the dimension, whose index should be returned |
Example
ElemChildIndex("Products";"Colnago";"Rock")
Returns 1, because Rock is the first Child-element of the parent Colnago
ElemChildIndex("Produkte";"Rock";"Colnago")
liefert -1, da Colnago kein Child-Element von Rock ist
