Sorry. Answered too fast. That was wrong.

What you need is more calculation fields that give you a counter for each level:

Level_1 = Case ( ValueCount ( chckBoxField ) = 1 ; 1 )
Level_2 = Case ( ValueCount ( chckBoxField ) = 2 ; 1 )
Level_3 = Case ( ValueCount ( chckBoxField ) = 3 ; 1 )
 ...
Level_n = Case ( ValueCount ( chckBoxField ) = n ; 1 )

Then have a matching set of summary fields that sum each of those additional calc fields.

j.

On May 14, 2012, at 10:20 AM, Jonathan Fletcher wrote:

> Put a calculation in each record that uses the ValueCount () function and then use a Summary field that sums that field.
> 
> j.
> 
> 
> On May 14, 2012, at 9:54 AM, John Montana wrote:
> 
>> Hi All,
>> 
>> I have a field with check boxes, 24 values.
>> 
>> I count the checked values per record with the ValueCount() function. Works great.
>> 
>> Now I need a way to know how many checked boxes per record in a found set.
>> 
>> Example.
>> 
>> Record 1 - 5, 3 boxes checked
>> Record 6, 4 boxes checked
>> Record 7 - 12, 6 boxes checked
>> 
>> Result:
>> 
>> 5 records with 3 boxes checked
>> 1 record with 4 boxes checked
>> 6 records with 6 boxes checked
>> 
>> Any hint how to start ?
> 
> 
> --
> Jonathan Fletcher
> FileMaker 9/10/11 Certified Developer
> 
> Fletcher Data Consulting
> [log in to unmask]
> http://www.fletcherdata.com
> 502-509-7137
> 
> Personal Blog o'Stuff: http://jfletch.posterous.com
> 
> Kentuckiana's FileMaker Users Group
> Next up: Build-from-scratch and more Twelve!
> Tuesday, May 22, 12:00 pm to 3:30-ish
> Blog: http://www.kyfmp.com


--
Jonathan Fletcher
FileMaker 9/10/11 Certified Developer

Fletcher Data Consulting
[log in to unmask]
http://www.fletcherdata.com
502-509-7137

Personal Blog o'Stuff: http://jfletch.posterous.com

Kentuckiana's FileMaker Users Group
Next up: Build-from-scratch and more Twelve!
Tuesday, May 22, 12:00 pm to 3:30-ish
Blog: http://www.kyfmp.com