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 > [email protected] > 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 [email protected] 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
