FMPRO-L Archives

May 2012, Week 2

FMPRO-L@LISTSERV.DARTMOUTH.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: Counting checked items in found set
From:
Jonathan Fletcher <[log in to unmask]>
Reply To:
FileMaker Pro Discussions <[log in to unmask]>
Date:
Mon, 14 May 2012 10:20:41 -0400
Content-Type:
text/plain
Parts/Attachments:
text/plain (46 lines) 
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

ATOM RSS1 RSS2