Excel Client:ElemLastSibling: Difference between revisions
From CoPlanner 11
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| Line 5: | Line 5: | ||
===Parameter=== | ===Parameter=== | ||
{| | {| class="wikitable" width="50%" | ||
|- | |- | ||
|width="200pt" style=background-color:#f6f6f6 |'''Dimension''' | |width="200pt" style=background-color:#f6f6f6 |'''Dimension''' | ||
| Line 17: | Line 17: | ||
===Example === | ===Example === | ||
{| | {| class="wikitable" width="50%" | ||
|- {{Tabellentitel}} | |||
|width="200pt" | |width="200pt" |Function | ||
| | |Result | ||
|- | |- | ||
|ElemLastSibling(„Zeit“; „SEP 2005“) | |ElemLastSibling(„Zeit“; „SEP 2005“) | ||
Revision as of 09:42, 6 March 2012
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
| Dimension | The dimension to which the operation applies. |
| Element | The element whose last “sibling element” is sought. |
Example
| Function | Result |
| ElemLastSibling(„Zeit“; „SEP 2005“) | „DEZ 2005“ |
