Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Formula Throwing "Infinity" or "NaN".

Status
Not open for further replies.

davida37

IS-IT--Management
May 10, 2006
113
GB
Hi,

- SQL Server 2005
- SSRS

I need to capture and deal with error handling in my report. It seems that some of the formula you would use in Excel - it not recognised in SSRS - i.e. IF(ISERROR(formula,"",formula)) ----->

=IIF(ISERROR((XXX.Value/YYY.Value),"",(XXX.Value/YYY.Value))

The report has these 3 errors which I dont know how to hande.
- #Error
- Infinity
- NaN

Thanks

David
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top