Left
Returns a specified number of characters from the left side (beginning) of a string.
Syntax
Left(String_Expression, Numeric_Expression)
Arguments
String_Expression | MDX expression that returns a string. |
|---|---|
Numeric_Expression | A numeric expression that specifies the number of characters to extract from the beginning of the string. |
Examples
Reporter name
The following formula returns the reporter's first name for an issue.
Left( [Measures].[Issue reporter], InStr([Measures].[Issue reporter], ' ') - 1 )
Issue first due date
The following formula returns the first assigned due date of an issue from the issue's "Due date old values" property.
Left(
[Issue].CurrentHierarchyMember.GetString('Due date old values'),
10
)
See also
- Function Right returns a specified number of characters from the right side (end) of a string.
- Function InStr returns the position of the first occurrence of one string within another.
- Function Mid returns a specified number of characters from a string, starting at a designated position.