Excel Client:ElemChildIndex: Difference between revisions
From CoPlanner 10
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| Line 29: | Line 29: | ||
<span {{CoPFormel}}>ElemChildIndex("Produkte";"Rock";"Colnago")</span> | <span {{CoPFormel}}>ElemChildIndex("Produkte";"Rock";"Colnago")</span> | ||
Returns -1, because Colnago is no child-element of Rock | |||
__NOEDITSECTION__ | __NOEDITSECTION__ | ||
[[Category:Excel_Client_Formulas|ElemChildIndex]] | [[Category:Excel_Client_Formulas|ElemChildIndex]] | ||
[[de:Excel_Client_2.0:ElemChildIndex]] | [[de:Excel_Client_2.0:ElemChildIndex]] | ||
Latest revision as of 16:45, 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")
Returns -1, because Colnago is no child-element of Rock
