Reporting Services SYNTAX help for EXPRESSION....????
Posted on 2008-10-09
I'm using this field for displaying a PERCENTAGE calc of 2 different COUNT FIELDS in my RS Report.
=cint(count(Fields!ORDERID.Value, "OrderCount") / Fields!CALLCOUNT.Value*100)& " %"
However, on occasion one or both of the COUNT FIELDS will be NULL and so I get an #ERROR displayed in the report when this happens. I would like this percentage calculation to display "N/A" when this happens instead of the system standard #ERROR.
Can someone help me with the SYNTAX needed in order to do this?