Excel Client:ElemFirstSibling: Difference between revisions
From CoPlanner 10
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
==ElemFirstSibling(Dimension, Element) | ==[[Excel_Client:Functions_(Formulas)|Function]]== | ||
<span {{CoPFormel}}>ElemFirstSibling(Dimension, Element)</span> | |||
This [[Excel_Client:Functions_(Formulas)|function]] returns the first element of the level on which the element is located. If the Element is not present in the dimension, an empty string (“”) is returned. | This [[Excel_Client:Functions_(Formulas)|function]] returns the first element of the level on which the element is located. If the Element is not present in the dimension, an empty string (“”) is returned. | ||
{| class="wikitable" width={{{breite|80%}}} | |||
|- {{Tabellentitel}} | |||
{| class="wikitable" width=" | | width="150px"|Parameter | ||
| Description | |||
|- | |- | ||
| | |Dimension | ||
|The dimension to which the operation applies. | |The dimension to which the operation applies. | ||
|- | |- | ||
| | |Element | ||
|The element whose first “sibling element” is sought. | |The element whose first “sibling element” is sought. | ||
|} | |} | ||
==Example== | |||
<span {{CoPFormel}}>ElemFirstSibling(„Zeit“; „SEP 2005“) </span><br> | |||
returns „JAN 2005“ | |||
__NOEDITSECTION__ | __NOEDITSECTION__ | ||
[[Category:Excel_Client_Formulas|ElemFirstSibling]] | [[Category:Excel_Client_Formulas|ElemFirstSibling]] | ||
[[de:Excel_Client:ElemFirstSibling]] | [[de:Excel_Client:ElemFirstSibling]] | ||
Revision as of 10:31, 24 May 2012
Function
ElemFirstSibling(Dimension, Element)
This function returns the first element of the level on which the element is located. If the Element is not present in the dimension, an empty string (“”) is returned.
| Parameter | Description |
| Dimension | The dimension to which the operation applies. |
| Element | The element whose first “sibling element” is sought. |
Example
ElemFirstSibling(„Zeit“; „SEP 2005“)
returns „JAN 2005“
