Excel Client:ElemParent: Difference between revisions

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


This [[Excel_Client:Functions_(Formulas)|function]] returns the element name of the Parent element of the element Element. If the Element is not present in the dimension, an empty string (“”) is returned.  
This [[Excel_Client:Functions_(Formulas)|function]] returns the element name of the Parent element of the element Element. If the Element is not present in the dimension, 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 whose Parent element is sought.
|The element whose Parent element is sought.
|}
|}


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


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

Revision as of 09:42, 24 May 2012

Function

ElemParent(Dimension, Element)

This function returns the element name of the Parent element of the element Element. 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 Parent element is sought.

Example

ElemParent(„Zeit“; „JAN 2005“)
returns „2005“