Document toolboxDocument toolbox

Format

Owned by Elvis Kvalbergs
Last updated: Aug 03, 2022 by Gvido

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.