Marcus Aurelius
asked on
Reporting Services SYNTAX help for EXPRESSION....????
Experts:
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?
I'm using this field for displaying a PERCENTAGE calc of 2 different COUNT FIELDS in my RS Report.
=cint(count(Fields!ORDERID
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?
ASKER
Didn't work I receive the same: #Error
M
M
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Still get: #Error
hmmm... I'd try the request attention link at the top and see what we're doing wrong here.
=iif(isnothing(cint(count(