Roundup MDX function

Feature Requests
1

This is a simple one, can we have a round up MDX formula? I work a lot with rounding up decimal values, although we have a solution X - MOD(X, 1) + 1 as stated in this post, if you use a lot of this that get the formula dificult to read to others inspecting the calculation
Here is a simple example:

NonZero(
  -- Roundup-> X - MOD(X, 1) + 1
  (
  (
    [Measures].[Downstream days],
    [Status.Category].[Done]
  )
  -
  MOD(
    (
      [Measures].[Downstream days],
      [Status.Category].[Done]
    ), 1) + 1
  )
)

Which could be simple as:

NonZero(Roundup(
  (
    [Measures].[Downstream days],
    [Status.Category].[Done]
  )
)

Although one solution is to put the tuple in a separate measure, if you do for each different roundup calculation the user defined measures area get really bloated.

2

Hello @Thomas_Kuryura,

Thanks for your post and the feedback. Roundup is not a Mondrian function and, hence, is not available in eazyBI.

We do have standard rounding options with the custom formatting: Calculated measures
and Round function: Round

However, they are rounding based on the mathematical rule where values of 0.5 and above are rounded up to the next integer, while values below 0.5 are rounded down to the previous integer.

I have registered your request as a Feature idea in our backlog and added your vote to it.

Best,
Marita / support@eazybi.com