Count of fields

[Poida]

This is probably very simple but I cannot figure out how to do it.

I want to be able show the count of certain fields who fall into different categories according to a value list. It is basically where a child's reading/writing/etc grade is counted. So there were 5 children in basic, 7 children in sound, 14 children in high, 7 children in outstanding etc etc. This is all displayed according to a found set and is calculated by a script. I just dont know how to get the count to work. I hope I am making sense.

Many thanx in advance.

Edited September 10, 2006 by Guest

[Søren Dyhr]

What worries me here is:

certain fields

...with a plural "s"! Shouldn't it be gathered in a single checkbox field?

But take a look at this template:

http://www.kevinfrank.com/download/counting-values.zip

But since you have categorized yourself as expert would there be nothing preventing you from tightning the algorithm up further by using this:

http://www.onegasoft.com/tools/fastsummaries/index.shtml

--sd

[Lee Brock]

Hi Søren,

Thanks in advance for you help. I'm just starting to learn FMP. I think I have a similar question. I think I kind of understand what the sample file from the link in your response is demonstrating but I haven't a clue how to customize it for my purposes.

I'm using the Business Productivity Solution Kit as a framework for my database. In the file bps_Sales_Orders.fp7/Sales Orders/Form View layout I've created a radio button field to indicate if the record is an Invoice or a Memo. The reason is I want to count the number of invoices (omitting the memos), the sum of which would be used to calculate the charge I have to pay per invoice (product fee per client).

This works fine for Requests but how do I get the calculation to appear in a report? This is probably a very easy thing, but when I start to read how to compile all the variable for writing scripts, my eyes start to roll around in my head. Note attractive. : Thank you, Lee

[Søren Dyhr]

Lee just to let you know, I've pulled an alias to my desktop on this thread, I've no intention to keep you in suspence but I have to finish something before...

Perhaps you could upload a clone of your developement so far, because I hardly ever poke into neither the standard templates nor these productivity kits, since I've been on this tool for at least 11 years ...and are usually making things from scratch, and only implement methods in "digested" form.

I do however see that you at least two occations tend to hijack threads, make instead a new one for this question and advice me of it via private messages!

--sd

Edited September 13, 2006 by Guest