Excel Client:ElemLastSibling: Difference between revisions

From CoPlanner 11
Jump to navigationJump to search
No edit summary
No edit summary
 
Line 18: Line 18:


==Example==
==Example==
<span {{CoPFormel}}>ElemLastSibling(„Zeit“; „SEP 2005“)</span><br>  
<span {{CoPFormel}}>ElemLastSibling("Zeit"; "SEP 2005")</span><br>  
returns „DEZ 2005“
returns „DEZ 2005“



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“