Excel Client:ElemNextMember: Difference between revisions

From CoPlanner 10
Jump to navigationJump to search
No edit summary
No edit summary
Line 1: Line 1:
==ElemNextMember(Dimension, Element) ==
==[[Excel_Client:Functions_(Formulas)|Function]]==
 
<span {{CoPFormel}}>ElemNextMember(Dimension, Element)</span>


This [[Excel_Client:Functions_(Formulas)|function]] returns the name of the element located at the position immediately after the element Element. If the Element is not present in the dimension or if there is no element at the position, an empty string (“”) is returned.  
This [[Excel_Client:Functions_(Formulas)|function]] returns the name of the element located at the position immediately after the element Element. If the Element is not present in the dimension or if there is no element at the position, an empty string (“”) is returned.  


===Parameter===
{| class="wikitable" width={{{breite|80%}}}
 
|- {{Tabellentitel}}
{| class="wikitable" width="50%"
| width="150px"|Parameter
| Description
|-
|-
|width="200pt" style=background-color:#f6f6f6 |'''Dimension''' 
|Dimension  
|The dimension to which the operation applies.
|The dimension to which the operation applies.
|-
|-
|style=background-color:#f6f6f6 |'''Element '''
|Element
|The element that serves as the basis.  
|The element that serves as the basis.  
|}
|}


 
==Example ==
===Example ===
<span {{CoPFormel}}>ElemNextMember(„Zeit“;“JUL 2005“) </span><br>
 
returns „AUG 2005“  
{| class="wikitable" width="50%"
|- {{Tabellentitel}}  
|width="200pt" |Function
|Result
|-
|ElemNextMember(„Zeit“;“JUL 2005“)  
|„AUG 2005“  
|}
 


__NOEDITSECTION__
__NOEDITSECTION__
[[Category:Excel_Client_Formulas|ElemNextMember]]
[[Category:Excel_Client_Formulas|ElemNextMember]]
[[de:Excel_Client:ElemNextMember]]
[[de:Excel_Client:ElemNextMember]]

Revision as of 10:41, 24 May 2012

Function

ElemNextMember(Dimension, Element)

This function returns the name of the element located at the position immediately after the element Element. If the Element is not present in the dimension or if there is no element at the position, an empty string (“”) is returned.

Parameter Description
Dimension The dimension to which the operation applies.
Element The element that serves as the basis.

Example

ElemNextMember(„Zeit“;“JUL 2005“)
returns „AUG 2005“