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
