Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

formatting a value in mdx

formatting a value in mdx

formatting a value in mdx

I am creating a claculated member in a cube. This requires the length of services (a figure in days to be converted to months. To do this I am using the arithmeitic as below.

(StrToValue([Company Structure D].CurrentMember.Properties("Days In Business"))*12/365.25)

Now how do I insure this only returns a whole value rather than a decimal ie 10 rather than 10.25

Many thanks.
Replies continue below

Recommended for you

RE: formatting a value in mdx

if the calc


(StrToValue([Company Structure D].CurrentMember.Properties("Days In Business"))*12/365.25)

gives your output only with the decimal try applying a format value so you would have


(StrToValue([Company Structure D].CurrentMember.Properties("Days In Business"))*12/365.25),FORMAT_STRING = '#,###'

if this claculated member is being stored within the cube then you can use the properties panel to control the ouput format.

Shoot Me! Shoot Me NOW!!!
                           - Daffy Duck

RE: formatting a value in mdx

I have formatted the string in the cube. However when the data is extracted from the cube then we are seeing the unformatted data rather than what we want.

Rather than alter the format I wish to ammend the value that is stored. ie dont format 119.47 but change its value to 119.

Many thanks.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close