Versions Compared

Old Version 1

changes.mady.by.user Elvis Kvalbergs

Saved on

compared with

New Version Current

changes.mady.by.user Gvido

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Formats a number or date to a string.

Syntax

Code Block
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 Block
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.