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