Floor Function in MDX

• narendra.babu57

  Old Hand

  Points: 386

  More actions

  December 19, 2014 at 2:12 am

  #314006

  Hi All,

  Is there any function like Floor function in MDX.

  Ex: 1) value is 1.9 then output is 1

  2) value is 1.1 then output is 1

  3) value is 0.4 then output is 0

  4) value is 0.5 then output is 0

  my aim is before dot(.) value i have to return. is there any function for this in mdx.

  Regards,

  Naru

• PB_BI

  SSCoach

  Points: 17461

  More actions

  January 8, 2015 at 2:19 am

  #1768706

  If returning whatever value is before the decimal is your only goal then you can just do some string manipulation and cast it as a number. In the following example, imagine that the [x] measure is your value:

  MEMBER [xFormat]

  AS

  StrToValue(LEFT([X], INSTR(CSTR([X]), ".")-1))

  There are floor functions available in MDX (via vba) but they do not do as you describe as far as I know.

  ---

  I'm on LinkedIn

• JonsDorh

  Grasshopper

  Points: 11

  More actions

  March 16, 2021 at 9:17 am

  #3858395

  When pouring a concrete floor, the calculation function is obligatory. It allows you to calculate the cost of materials and the work itself. Our company has been dealing with concrete floors for more than 10 years, more details on the website.