ValueList Question - determining the % of check boxes selected per record.
I have a value list of items. This value list is used with one field. The field is configured as a CHECK BOX using the value list.
What I want to do: calculate the % of boxes checked in each record.
What I can do: using ValueCount(), I can easily determine how many check boxes have been selected in each record.
Help: How do I calculate the total number of check box items possible (would be the same for all records)? Once I have that number, then I can easily calculate the % selected for that field in each record.
Thanks for the assistance. Greatly appreciated.