Oct 23 2006, 03:42 PM
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"?
Oct 23 2006, 03:48 PM
I think I got it, although it may not be the smoothest solution.
Oct 23 2006, 04:22 PM
If you'd like to post your current solution, we maybe able to smoothen it up a little
Oct 23 2006, 05:52 PM
I have the following:
It works, but I don't know if there's a shorter way.
Eithe way, thanks everybody for your patience.
Oct 23 2006, 06:42 PM
Oct 24 2006, 07:19 AM
If your control is actually a Yes/No type rather than a text field that holds either "Y" or "N" then something like
should also work & is simpler
Best of Luck
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here