formatting a value in mdx

[MarkElls]

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

 

[MDXer]

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

 

[MarkElls]

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