Click here to Skip to main content
15,905,322 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
How to handle #ERROR, NAN and INFINITY in a single expression in SSRS report my expression looks like this (Current-Previous)/Previous*100.

What I have tried:

I tried like this

=IIF((SUM(Current)="" OR SUM(Previous) = ""),"",(SUM(Current) - SUM(Previous))) / SUM(Previous)

but it was giving error for all
[no name] 29-Dec-22 10:17am    
SSRS is a "reporting system"; garbage in, garbage out; you need to "cleanse" your reporting data.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900