This is a migrated thread and some comments may be shown as answers.

Easy way to make it so Nan and Infinity don't show up

1 Answer 162 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
TechSavvySam
Top achievements
Rank 1
TechSavvySam asked on 01 Aug 2014, 04:01 PM
Is there a field property to have the resulting value be the empty string when an expression evaluates to NaN or Infinity?

I know how to work around this by using a string property that formats the value for me, but I was wondering if there was a code-less way.

Thanks

1 Answer, 1 is accepted

Sort by
0
TechSavvySam
Top achievements
Rank 1
answered on 01 Aug 2014, 07:38 PM
Here's the annoying way to do it:

=IIF(Fields.Posts=0,'',CDbl(Sum(Fields.TotalMs))/ CDbl(Sum(Fields.Posts)))
Tags
General Discussions
Asked by
TechSavvySam
Top achievements
Rank 1
Answers by
TechSavvySam
Top achievements
Rank 1
Share this question
or