Excel Client:ElemSelect: Difference between revisions
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
==ElemSelect(Dimension, Element) | ==[[Excel_Client:Functions_(Formulas)|Function]]== | ||
<span {{CoPFormel}}>ElemSelect(Dimension, Element)</span> | |||
A cell containing a formula of this kind serves as a filter cell in the CoPlanner Excel Client. By double-clicking on this cell, you can open a dialogue that displays the dimension as a tree (see [[Excel_Client:Transferring_a_Report_into_Excel#Changing_a_filter|Editing a Filter]]). The desired element can be selected from the tree. If the element is not present for any reason, a value of “E.n.F.” is returned (see [[Excel_Client:Constants_and_Return_Values|Constants and Return Values]]). | A cell containing a formula of this kind serves as a filter cell in the CoPlanner Excel Client. By double-clicking on this cell, you can open a dialogue that displays the dimension as a tree (see [[Excel_Client:Transferring_a_Report_into_Excel#Changing_a_filter|Editing a Filter]]). The desired element can be selected from the tree. If the element is not present for any reason, a value of “E.n.F.” is returned (see [[Excel_Client:Constants_and_Return_Values|Constants and Return Values]]). | ||
{| class="wikitable" width={{{breite|80%}}} | |||
|- {{Tabellentitel}} | |||
{| class="wikitable" width={{{breite| | | width="150px"|Parameter | ||
|- | | Description | ||
|width=" | |- | ||
|Dimension | |||
|The name of the dimension. | |The name of the dimension. | ||
|- | |- | ||
| | |Element | ||
|The selected element. | |The selected element. | ||
|} | |} | ||
==Example == | |||
<span {{CoPFormel}}>ElemSelect(„Produkte“;„Rennräder“)</span><br> | |||
returns Rennräder | |||
The function can be expanded to offer the option of creating a plan selector. To do so, please use “Plan” as your dimension name. When you subsequently double-click on the cell containing the function, the plan selector will be displayed. If a plan is not (or no longer) present in the model, the function will return a value of “P.n.F.” (See [[Excel_Client:Constants_and_Return_Values|Constants and Return Values]]). | The function can be expanded to offer the option of creating a plan selector. To do so, please use “Plan” as your dimension name. When you subsequently double-click on the cell containing the function, the plan selector will be displayed. If a plan is not (or no longer) present in the model, the function will return a value of “P.n.F.” (See [[Excel_Client:Constants_and_Return_Values|Constants and Return Values]]). | ||
<span {{CoPFormel}}>ElemSelect(„Plan“;„Budget 2006“)</span><br> | |||
returns „Budget 2006“ | |||
__NOEDITSECTION__ | __NOEDITSECTION__ | ||
[[Category:Excel_Client_Formulas|ElemSelect]] | [[Category:Excel_Client_Formulas|ElemSelect]] | ||
[[de:Excel_Client:ElemSelect]] | [[de:Excel_Client:ElemSelect]] | ||
Revision as of 10:45, 24 May 2012
Function
ElemSelect(Dimension, Element)
A cell containing a formula of this kind serves as a filter cell in the CoPlanner Excel Client. By double-clicking on this cell, you can open a dialogue that displays the dimension as a tree (see Editing a Filter). The desired element can be selected from the tree. If the element is not present for any reason, a value of “E.n.F.” is returned (see Constants and Return Values).
| Parameter | Description |
| Dimension | The name of the dimension. |
| Element | The selected element. |
Example
ElemSelect(„Produkte“;„Rennräder“)
returns Rennräder
The function can be expanded to offer the option of creating a plan selector. To do so, please use “Plan” as your dimension name. When you subsequently double-click on the cell containing the function, the plan selector will be displayed. If a plan is not (or no longer) present in the model, the function will return a value of “P.n.F.” (See Constants and Return Values).
ElemSelect(„Plan“;„Budget 2006“)
returns „Budget 2006“
