Excel Client:ElemSelect: Difference between revisions
No edit summary |
No edit summary |
||
| Line 18: | Line 18: | ||
==Example == | ==Example == | ||
<span {{CoPFormel}}>ElemSelect( | <span {{CoPFormel}}>ElemSelect("Produkte";"Rennräder")</span><br> | ||
returns 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 [[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( | <span {{CoPFormel}}>ElemSelect("Plan";"Budget 2006")</span><br> | ||
returns „Budget 2006“ | returns „Budget 2006“ | ||
Latest revision as of 14:58, 15 April 2014
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“
