Post reply

Function To Format Number In MDX

  • March 30, 2005 at 1:31 am

    #163968

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

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

     

  • March 31, 2005 at 5:28 pm

    #549954

    Thanks, it works

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply