Excel Client:ElemChildIndex - Revision history

Admin at 14:45, 14 April 2015

2015-04-14T14:45:44Z

← Older revision		Revision as of 15:45, 14 April 2015
Line 29:		Line 29:
	<span {{CoPFormel}}>ElemChildIndex("Produkte";"Rock";"Colnago")</span>		<span {{CoPFormel}}>ElemChildIndex("Produkte";"Rock";"Colnago")</span>

	~~liefert~~ -1, da Colnago ~~kein Child~~-~~Element von~~ Rock ~~ist~~		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]]

Admin at 14:41, 14 April 2015

2015-04-14T14:41:43Z

← Older revision		Revision as of 15:41, 14 April 2015
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==

Admin at 14:41, 14 April 2015

2015-04-14T14:41:26Z

← Older revision		Revision as of 15:41, 14 April 2015
Line 33:		Line 33:

	__NOEDITSECTION__		__NOEDITSECTION__
	[[Category:~~Excel_Client_formula~~\|ElemChildIndex]]		[[Category:Excel_Client_Formulas\|ElemChildIndex]]
	[[de:Excel_Client_2.0:ElemChildIndex]]		[[de:Excel_Client_2.0:ElemChildIndex]]

Admin: Created page with "==Function== ElemChildIndex(DimensionName, Parent, Child) This [[Excel_Client:Functions_(Formulas)|function]..."

2015-04-14T14:41:03Z

Created page with "==Function== ElemChildIndex(DimensionName, Parent, Child) This [[Excel_Client:Functions_(Formulas)|function]..."

New page

==[[Excel_Client:Functions_(Formulas)|Function]]==

ElemChildIndex(DimensionName, Parent, Child)

This [[Excel_Client:Functions_(Formulas)|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.

{| class="wikitable" width={{{breite|80%}}}
|- {{Tabellentitel}}
| width="150px"|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

__NOEDITSECTION__
[[Category:Excel_Client_formula|ElemChildIndex]]
[[de:Excel_Client_2.0:ElemChildIndex]]