SSRS 2005 decision function for number values.

In a SSRS 2005 report I am comming backw ith values of 'Infinity %'  & "NaN %" - - how can I write a statement in which I can substitute these results for '0 %' instead to avoid end user confusion.

Thanks Experts!
Levi MartinSenior Data AnalystAsked:
Who is Participating?
 
SQL_SERVER_DBACommented:
maybe...
IIF(Fields!columnname.Value="Infinity", "0", Fields!columnname.Value)
0
 
chrismcCommented:
Switch is another function for this sort of stuff, but IIf is generally more useful.
Look them up in Books Online for exact syntax.

Cheers
Chris
0
 
Levi MartinSenior Data AnalystAuthor Commented:
SQL SERVER DBA - - your idea worked like a charm...ideas on how I can capture something like "Infinity" or "NaN?

Thanks!
0
 
Levi MartinSenior Data AnalystAuthor Commented:
NM...OR worked just fine.

Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.