/
Format
Document toolboxDocument toolbox

Support center for flex.bi version 3.2

Format

Owned by Gvido
Last updated: Sept 02, 2016

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([Issue].CurrentMember.Name, 
      '.*-(\d+)', 1
    )
  ),"000"
)

Above example will return a string value of Issue Name that follows after - formatted to three digits. So if the Issue name is Demo-12, the returned result would be 012.

See also

ExtractString and Val functions that are used in the example.