[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Handle Null values in calculated measure and excel

Posted on 2014-08-24
1
Medium Priority
?
164 Views
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.

sum(
{[Pack Type].[Pack Type].&[Hanging Sack]},[Measures].[Totes]
       )
 
Thanks,

Sreekanth.
0
Comment
Question by:n_srikanth4
1 Comment
 
LVL 25

Accepted Solution

by:
chaau earned 2000 total points
ID: 40282459
Try to use COALESCEEMPTY to replace the empty values with zeroes, like this:
COALESCEEMPTY(sum(
{[Pack Type].[Pack Type].&[Hanging Sack]},[Measures].[Totes]
       ), 0)

Open in new window

0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

834 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