Solved

Trouble with NaN

Posted on 2008-11-03
1
972 Views
Last Modified: 2012-06-27
I am trying to remove the NaN from this report item and can't seem to get it right.  Here is the expression.
=IIF(IsNumeric(Sum(Fields!excessiveNoiseResolved.Value)/sum(Fields!excessiveNoise.Value)),Sum(Fields!excessiveNoiseResolved.Value)/sum(Fields!excessiveNoise.Value),100)
0
Comment
Question by:simprick
1 Comment
 
LVL 2

Accepted Solution

by:
simprick earned 0 total points
ID: 22869225
Found the anwser by using a function that checks for NaN.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.

831 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