Excel Client:ElemLastSibling: Difference between revisions
From CoPlanner 10
Jump to navigationJump to search
Created page with '==ElemLastSibling(Dimension, Element)== This returns the last element of the level on which the element is located. If the Element is not present in the dimension, an empty stri…' |
No edit summary |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
== | ==[[Excel_Client:Functions_(Formulas)|Function]]== | ||
<span {{CoPFormel}}>ElemLastSibling(Dimension, Element)</span> | |||
This [[Excel_Client:Functions_(Formulas)|function]] returns the last 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}} | |||
| width="150px"|Parameter | |||
| Description | |||
|- | |- | ||
| | |Dimension | ||
|The dimension to which the operation applies. | |The dimension to which the operation applies. | ||
|- | |- | ||
| | |Element | ||
|The element whose last “sibling element” is sought. | |The element whose last “sibling element” is sought. | ||
|} | |} | ||
==Example== | |||
<span {{CoPFormel}}>ElemLastSibling("Zeit"; "SEP 2005")</span><br> | |||
returns „DEZ 2005“ | |||
__NOEDITSECTION__ | __NOEDITSECTION__ | ||
[[Category:Excel_Client_Formulas|ElemLastSibling]] | [[Category:Excel_Client_Formulas|ElemLastSibling]] | ||
[[de:Excel_Client:ElemLastSibling]] | [[de:Excel_Client:ElemLastSibling]] | ||
Latest revision as of 14:55, 15 April 2014
Function
ElemLastSibling(Dimension, Element)
This function returns the last 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 last “sibling element” is sought. |
Example
ElemLastSibling("Zeit"; "SEP 2005")
returns „DEZ 2005“
