Right
Returns a specified number of characters from the right side (end) of a string.
Syntax
Right(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 end of the string. |
Examples
Issue resolution time
The following formula returns the time when an issue was resolved (without the date).
Right(
[Issue].CurrentHierarchyMember.GetString('Resolved at'),
8
)
See also
- Function Left returns a specified number of characters from the left side (beginning) of a string.
- Function Mid returns a specified number of characters from a string, starting at a designated position.