I have a standard report with a column that can either be "Y" or "N". This column name is called "Complete".

In the footer, how can I provide the percentage of the total that are "Y"?

Thanks.

I think I got it, although it may not be the smoothest solution.

Thanks.

If you'd like to post your current solution, we maybe able to smoothen it up a little

I have the following:

=(Sum(IIf([Complete]="Y",1,0)))/Count(*)

It works, but I don't know if there's a shorter way.

Eithe way, thanks everybody for your patience.

Looks fine

If your control is actually a Yes/No type rather than a text field that holds either "Y" or "N" then something like

=-(Sum([Complete])/Count(*))

should also work & is simpler

Best of Luck

Ian