Excel Client:ElemParent: Difference between revisions
From CoPlanner 10
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| 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. | ||
{| class="wikitable" width={{{breite|80%}}} | |||
|- {{Tabellentitel}} | |||
{| class="wikitable" width=" | | width="150px"|Parameter | ||
| Description | |||
|- | |- | ||
| | |Dimension | ||
|The dimension to which the operation applies. | |The dimension to which the operation applies. | ||
|- | |- | ||
| | |Element | ||
|The element whose Parent element is sought. | |The element whose Parent element is sought. | ||
|} | |} | ||
==Example == | |||
<span {{CoPFormel}}>ElemParent("Zeit"; "JAN 2005") </span><br> | |||
returns „2005“ | |||
{ | |||
__NOEDITSECTION__ | __NOEDITSECTION__ | ||
[[Category:Excel_Client_Formulas|ElemParent]] | [[Category:Excel_Client_Formulas|ElemParent]] | ||
[[de:Excel_Client:ElemParent]] | [[de:Excel_Client:ElemParent]] | ||
Latest revision as of 13:54, 15 April 2014
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“
