I have two fields one called incident number and another called problem number, the incident number field will always be populated whereas the problem number field will not be. I wish to calculate the percentage of incident number fields that have the problem number field populated. Can anyone provide me with an expression that would show this? Thanks Roisin Lautman

Try This for Percentage Text Box =IIF((Not IsNothing(Fields!Problem.Value)) And (Fields!Problem.Value <> ""),((Fields!Incident.Value/Fields!Problem.Value) * 100),Fields!Incident.Value) Or =IIF((Not IsNothing(Fields!Problem.Value)) And (Fields!Problem.Value <> ""),((Fields!Incident.Value/Fields!Problem.Value) * 100),0) If you want 0 if Problem No is Blank then try second one the first one will return Incident number as Percent if Problem is Blank and if the values are non numeric i.e. String then use CDec(Value) to conver to Decimal -------------------------------------------------------- Surender Singh Bhadauria

Both these expressions are displaying as #Error I was thinking of trying =Sum(Fields!Problem_ID.Value)/ Count(Fields!Incident_Number.Value) could this work?

=Sum(IIF(IsNothing(Fields!Problem_ID.Value), 0, 1))/Count(Fields!Incident_Number.Value) may work.Remember to mark as an answer if this post has helped you.

HI RLautman, Use this IIF((isnothing(problemnumber) or (problemnumber.value=0)),0,((IncidentNumber*100)/ProblemNumber)) Hope this will help Please mark as answer if helpful Amit