Excel Client:ElemIsAncle: 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: | ||
==ElemIsAncle(Dimension, Ancle, Parent) | ==[[Excel_Client:Functions_(Formulas)|Function]]== | ||
<span {{CoPFormel}}>ElemIsAncle(Dimension, Ancle, Parent)</span> | |||
This [[Excel_Client:Functions_(Formulas)|function]] returns a value of True if the element Ancle is a “grandchild” of the element Parent. Otherwise it returns a value of False. The value of False is also returned if Ancle or Parent is not present as an element in the dimension. | This [[Excel_Client:Functions_(Formulas)|function]] returns a value of True if the element Ancle is a “grandchild” of the element Parent. Otherwise it returns a value of False. The value of False is also returned if Ancle or Parent is not present as an element in the dimension. | ||
{| 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. | ||
|- | |- | ||
| | |Ancle | ||
|Grandchild element | |Grandchild element | ||
|- | |- | ||
| | |Parent | ||
|Parent Element | |Parent Element | ||
|- | |- | ||
|} | |} | ||
==Example == | |||
<span {{CoPFormel}}>ElemIsAncle("CopDim.dim_sys_zeit";"JAN 2005"; "dim_sys_zeit")</span><br> | |||
returns True | |||
__NOEDITSECTION__ | __NOEDITSECTION__ | ||
[[Category:Excel_Client_Formulas|ElemIsAncle]] | [[Category:Excel_Client_Formulas|ElemIsAncle]] | ||
[[de:Excel_Client:ElemIsAncle]] | [[de:Excel_Client:ElemIsAncle]] | ||
Latest revision as of 14:50, 15 April 2014
Function
ElemIsAncle(Dimension, Ancle, Parent)
This function returns a value of True if the element Ancle is a “grandchild” of the element Parent. Otherwise it returns a value of False. The value of False is also returned if Ancle or Parent is not present as an element in the dimension.
| Parameter | Description |
| Dimension | The dimension to which the operation applies. |
| Ancle | Grandchild element |
| Parent | Parent Element |
Example
ElemIsAncle("CopDim.dim_sys_zeit";"JAN 2005"; "dim_sys_zeit")
returns True
