Handling Section by the No problems in the MDX Calculations
YTD – “Automatically, per year level try asked. Zero such as height is actually based in the cube” Mistake for the MDX
Handling Split up by Zero problems are essential inside the MDX. Put another way we are able to call-it given that Separated by NULL errors in the MDX. New mistake that show after you make an effort to separate by the No/Null are “1.#INF”. Allows find a tiny example.
Now I have authored a computation to check on (Transformation Matter)/(Write off Number) for everyone services new inquire ends up –
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 manage the aforementioned inquire you can find of several thinking upcoming while the “step one.#INF” because Discount Number are often NULL otherwise 0 for the majority situations and you can PFB Screenshot of the identical.
Lets observe can we incorporate IIF reputation in order to end this type of errors. The IIF Standing syntax inside MDX is just as down the page.
IIF(standing,real,false) – If the status is true following basic area might possibly be conducted more second given about iff reputation. The fresh query ends up below just after applying IIF status.
with member [Measures].[Sales to Discount] as iif([Measures].[Discount Amount] = 0,null,[Measures].[Sales Amount]/[Measures].[Discount Amount]) SELECT on COLUMNS , [Dim Product].[English Product Name].[English Product Name] on ROWS from [Adventure Works DW]
About more than ask I’m indicating that if Disregard Matter are 0 following place NULL on the device regarding computed size output more calculate the value. This new production will in this way –
- Tags
- 1.#inf mistake
- Handling Office by the Zero errors
5 Statements
Just how to understand whether you are starting every little thing securely? When you look at the this, you are going to finest be able to get on cardio of them passionate Chinese females like you find your self which have a western lady. (lebih…)