Skip to main content
Skip table of contents

Format

Formats a number or date to a string.

Syntax

CODE
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

CODE
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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.