YTD – “By default, per year level are asked. Zero such as for example height are based in the cube” Mistake inside MDX

Handling Split up by Zero problems are very important within the MDX. This means we are able to refer to it as since Separated of the NULL errors into the MDX. This new error that demonstrate when you just be sure to split by Zero/Null try “1.#INF”. Lets find a little analogy.

Today I have composed a formula to check on (Sales Number)/(Disregard Count) for all products and the new ask turns out –

with member [Measures].[Sales to Discount] as [Measures].[Sales Amount]/[Measures].[Discount Amount] SELECT on COLUMNS , [Dim Product].[English Product Name].[English Product Name] on ROWS from [Adventure Works DW]

For people who work on these query you can see many beliefs coming given that “step 1.#INF” as the Dismiss Count is actually either NULL otherwise 0 for almost all things and you may PFB Screenshot of the identical. Read more