Excel Client:ElemSelect: Difference between revisions
Created page with '==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 …' |
No edit summary |
||
| Line 5: | Line 5: | ||
===Parameter=== | ===Parameter=== | ||
{| | {| class="wikitable" width={{{breite|50%}}} | ||
|- | |- | ||
|width="210pt" style=background-color:#f6f6f6 |'''Dimension''' | |width="210pt" style=background-color:#f6f6f6 |'''Dimension''' | ||
|The name of the dimension. | |The name of the dimension. | ||
| Line 17: | Line 17: | ||
===Example === | ===Example === | ||
{| | {| class="wikitable" width={{{breite|50%}}} | ||
|- | |- | ||
|width="210pt" style=background-color:#f6f6f6 |'''Function''' | |width="210pt" style=background-color:#f6f6f6 |'''Function''' | ||
| Line 32: | Line 32: | ||
===Example === | ===Example === | ||
{| | {| class="wikitable" width={{{breite|50%}}} | ||
|- | |- {{Tabellentitel}} | ||
|width="210pt" | |width="210pt" |Function | ||
| | |Result | ||
|- | |- | ||
|ElemSelect(„Plan“;„Budget 2006“) | |ElemSelect(„Plan“;„Budget 2006“) | ||
Revision as of 09:19, 6 March 2012
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
| Dimension | The name of the dimension. |
| Element | The selected element. |
Example
| Function | Result |
| ElemSelect(„Produkte“;„Rennräder“) | 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).
Example
| Function | Result |
| ElemSelect(„Plan“;„Budget 2006“) | „Budget 2006“ |
