Greetings. I have a report that I'd like to create a scorecard within. The scores will be expressed as percentages. I have 8 categories of tasks, and each category has a differing number of activities within it. When an activity is completed, the user checks a box indicating it is done. So I'd like to calculate the percentage of a category. I've tried creating a control that has =Abs([Task_1_1_Flag]+[Task_1_2_Flag])/2 in the On Update and On Enter to just calculate the percentage on the fly when the report is accessed, but the field is blank when loaded despite 1 of the 2 checkboxes displaying as checked on the report. The percentages don't necessarily need to be stored in the table, but could be if that's easier. Much thanks!
Calculating an average from checkboxes?
- Thread starter twitchie
- Start date
