Jump to content

Count of fields


Poida

This topic is 6460 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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 by Guest
Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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 by Guest
Link to comment
Share on other sites

This topic is 6460 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.