Function To Format Number In MDX

• Hendra Eka Putra

  SSCrazy

  Points: 2015

  More actions

  March 30, 2005 at 1:31 am

  #163968

  What function use to format a number - similiar as format function on VBA?

• mdaniel

  SSCarpal Tunnel

  Points: 4616

  More actions

  March 31, 2005 at 1:10 pm

  #549908

  I've done this with calculated members using FORMAT_STRING, like this:

  WITH MEMBER Measures.Profit AS'(Measures.[Sales] - Measures.[Cost])', FORMAT_STRING = '#,0.00'

  I think this can also be used in the cell properties section to format returned values, also when you create the member in the cube you can specify the format.

• Hendra Eka Putra

  SSCrazy

  Points: 2015

  More actions

  March 31, 2005 at 5:28 pm

  #549954

  Thanks, it works