Excel Client:ElemIsSubElement: Difference between revisions
From CoPlanner 10
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| Line 25: | Line 25: | ||
<span {{CoPFormel}}>ElemIsChild("Zeit";"JAN 2015";"2015") </span><br> | <span {{CoPFormel}}>ElemIsChild("Zeit";"JAN 2015";"2015") </span><br> | ||
returns " | returns "FALSE" | ||
| Line 35: | Line 35: | ||
<span {{CoPFormel}}>ElemIsChild("Zeit";"Zeit";"JAN 2015") </span><br> | <span {{CoPFormel}}>ElemIsChild("Zeit";"Zeit";"JAN 2015") </span><br> | ||
Returns "TRUE" | |||
__NOEDITSECTION__ | __NOEDITSECTION__ | ||
[[Category:Excel_Client_Formulas|ElemIsSubElement]] | [[Category:Excel_Client_Formulas|ElemIsSubElement]] | ||
[[de:Excel_Client_2.0:ElemIsSubElement]] | [[de:Excel_Client_2.0:ElemIsSubElement]] | ||
Latest revision as of 16:53, 14 April 2015
Function
ElemIsSubelement(DimensionName, ParentElement, ChildElement)
This function returns "TRUE" if the child element is a subelement of any level of the specified parent element, otherwise "FALSE". If child or parent is not included as an element in the dimension also "FALSE" will be returned. |}
| Parameter | Description |
| DimensionName | Dimension which is referenced |
| ParentElement | Element of the dimension, which should be a parent of the specified child element |
| ChildElement | Element of the dimension, which should be subordinate to the specified parent element |
Example
ElemIsChild("Zeit";"JAN 2015";"2015")
returns "FALSE"
ElemIsChild("Zeit";"2015";"JAN 2015")
Returns "TRUE"
ElemIsChild("Zeit";"Zeit";"JAN 2015")
Returns "TRUE"
