Handle Null values in calculated measure and excel

Posted on 2014-08-24
Last Modified: 2015-04-15
Hi Experts,

I am always getting the (null) value while browsing the cube for the dimesnion packtype value (Hanging Sacks) , I am unsure why I am getting a null value and hence I am getting the #value error in Excel.  So the user is unable to see any data i report. Please correct my MDX below and  resolve this issue.

Here is the MDX used for the calculated measure.

{[Pack Type].[Pack Type].&[Hanging Sack]},[Measures].[Totes]

Question by:n_srikanth4
    1 Comment
    LVL 24

    Accepted Solution

    Try to use COALESCEEMPTY to replace the empty values with zeroes, like this:
    {[Pack Type].[Pack Type].&[Hanging Sack]},[Measures].[Totes]
           ), 0)

    Open in new window


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Suggested Solutions

    A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now