How to handle #ERROR, NAN and INFINITY in a single expression in SSRS report my expression looks like this (Current-Previous)/Previous*100.
I tried like this
=IIF((SUM(Current)="" OR SUM(Previous) = ""),"",(SUM(Current) - SUM(Previous))) / SUM(Previous)
but it was giving error for all
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)