Solved

When ever the my expression returns a zero, the column cell read Nan,  how can I fix this?

Posted on 2011-02-28
2
634 Views
Last Modified: 2012-06-27
In a report I have an expression in Col A.
colA expression
= sum(colB)/sum(ColC)
This works.

However, wherever there is a zero after the expression runs,  colA returns Nan.

What is the best way to eliminate this problem?
0
Comment
Question by:rhservan
2 Comments
 
LVL 15

Accepted Solution

by:
derekkromm earned 500 total points
ID: 34997199
try this:

Iif(ISNOTHING(sum(colB)/sum(colC), 0, sum(colB)/sum(colC))
0
 

Expert Comment

by:CPA_MCSE
ID: 35155918
THE ACCEPTED SOLUTION IS WRONG.

THE CORRECT SOLUTION IS:

Iif(ISNOTHING(sum(colB)), 0, sum(colB)/sum(colC))

If colB is blank or not there, it will return a 0 instead.
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

746 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

8 Experts available now in Live!

Get 1:1 Help Now