sql server reporting services: Eliminating "Nan" in reports -- sql server reporting services

You're in the

sql server reporting services

group:

Eliminating "Nan" in reports

SK
5/23/2006 9:17:02 AM

sql server reporting services:

I'd like to eliminate "Nan" in my reports and I've tried various versions of
IIF, but keep getting an error message.

This is what I want/have:

= Sum(Fields!SubWin.Value, "WinRate1_All")+ Sum(Fields!PrimeWin.Value,
"WinRate1_All")/ Sum(Fields!SubWin.Value, "WinRate1_All")+
Sum(Fields!PrimeWin.Value, "WinRate1_All")+ Sum(Fields!SubLoss.Value,
"WinRate1_All")+ Sum(Fields!PrimeLoss.Value, "WinRate1_All")

Re: Eliminating "Nan" in reports

dba56
5/23/2006 10:21:58 AM

You are probably dividing by zero. Try something like

=IIF(Sum(Fields!SubWin.Value, "WinRate1_All")+
Sum(Fields!PrimeWin.Value, "WinRate1_All")+ Sum(Fields!SubLoss.Value,
"WinRate1_All")+ Sum(Fields!PrimeLoss.Value, "WinRate1_All") <> 0,
Sum(Fields!SubWin.Value, "WinRate1_All")+ Sum(Fields!PrimeWin.Value,
"WinRate1_All")/ Sum(Fields!SubWin.Value, "WinRate1_All")+
Sum(Fields!PrimeWin.Value, "WinRate1_All")+ Sum(Fields!SubLoss.Value,
"WinRate1_All")+ Sum(Fields!PrimeLoss.Value, "WinRate1_All"),0)

This way you are only performing the division if the denominator is not
zero. If the denominator is zero, then return a zero.

Re: Eliminating "Nan" in reports

SK
5/23/2006 2:06:02 PM

That worked perfectly!

Thank you so very much for your response!

[quoted text, click to view]

Re: Eliminating "Nan" in reports

SK
5/23/2006 2:08:02 PM

That was perfect!

Thank you very much for your response!

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn