H I have a field which brings back 2 results "Total" and "Missed". I want to bring back the results and then I need to find the percentage of "Missed". I can easily get a percentage from 2 seperate fields but how do you get a percentage from one field. I tried Scope but the report won't run I am using 2008 Thanks in advance Emma

Hi Emma Can you post some example data? Am finding it a bit hard to follow when you talk about one field which 'brings back 2 results'. Just wondering how a single field can contain two different things.

Hi Emma Can you post some example data? Am finding it a bit hard to follow when you talk about one field which 'brings back 2 results'. Just wondering how a single field can contain two different things.

Hi Emma, Try the following expression: =SUM(IIF(Fields!field.value="Missed",1,0))/Count(fields!field.value) If it does not help, give us more details here. thanks, Jerry