Excel Client:ElemPrevMember: Difference between revisions
From CoPlanner 11
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
==ElemPrevMember(Dimension, Element) | ==[[Excel_Client:Functions_(Formulas)|Function]]== | ||
<span {{CoPFormel}}>ElemPrevMember(Dimension, Element)</span> | |||
This [[Excel_Client:Functions_(Formulas)|function]] returns the name of the element located at the position immediately before the element Element. If the Element is not present in the dimension or if there is no element at the position, an empty string (“”) is returned. | This [[Excel_Client:Functions_(Formulas)|function]] returns the name of the element located at the position immediately before the element Element. If the Element is not present in the dimension or if there is no element at the position, an empty string (“”) is returned. | ||
{| 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. | ||
|- | |- | ||
| | |Element | ||
|The element that serves as the basis. | |The element that serves as the basis. | ||
|} | |} | ||
==Example == | |||
<span {{CoPFormel}}>ElemPrevMember("Zeit";"JUL 2005")</span><br> | |||
returns „JUN 2005“ | |||
__NOEDITSECTION__ | __NOEDITSECTION__ | ||
[[Category:Excel_Client_Formulas|ElemPrevMember]] | [[Category:Excel_Client_Formulas|ElemPrevMember]] | ||
[[de:Excel_Client:ElemPrevMember]] | [[de:Excel_Client:ElemPrevMember]] | ||
Latest revision as of 14:57, 15 April 2014
Function
ElemPrevMember(Dimension, Element)
This function returns the name of the element located at the position immediately before the element Element. If the Element is not present in the dimension or if there is no element at the position, an empty string (“”) is returned.
| Parameter | Description |
| Dimension | The dimension to which the operation applies. |
| Element | The element that serves as the basis. |
Example
ElemPrevMember("Zeit";"JUL 2005")
returns „JUN 2005“
