Formats a number or date to a string.
Syntax
Format(Numeric_Expression, String)
Format(DateTime, String)
Arguments
|
Numeric_Expression |
MDX expression that returns number. |
|---|---|
|
DateTime |
Date expression. |
|
String |
String that defines formatting of result. |
Examples
Format(
Val(
ExtractString([Project (Job)].CurrentMember.Name,
'.*-(\d+)', 1)
)
)
Above example will return a string value of Project Name that follows after - formatted to three digits. So if the Project name is Demo-12, then the returned value will be 12.
See also
ExtractString and Val functions that are used in the example.