generate totals based on specific values

[madman411]

hey guys

i have developed a layout on my database which lists all of the records created in a specific table. i have one calculation on the layout which displays the number of records in the given table with the simple calculation of get(found count) which works perfectly. now i want to go that little bit further and have totals generated depending on some specific values that are in those records.

for example: each record has one of the following values: scope, flat, 3d scope, 3d flat, or other. in addition to the total records found calculation, i would like a calculation individually displaying the total records found that are scope, flat, 3d scope, 3d flat, etc. i'm unsure on how to modify my previous calculation to meet these needs. it keep turning up ? values.

any ideas?

thanks!

[Aussie John]

You could use a summary field using the count option of that field which uses the respective types you indicated. Create a report using a subsummary based on that field. You might need to research subsummaries in the help manual.

Alternatively If you want to have a count show on on the record make a self join relationship using that field and create a "count" calculation making sure you base the calculation on the other related table

[madman411]

You could use a summary field using the count option of that field which uses the respective types you indicated. Create a report using a subsummary based on that field. You might need to research subsummaries in the help manual.

Alternatively If you want to have a count show on on the record make a self join relationship using that field and create a "count" calculation making sure you base the calculation on the other related table

aussie john, thanks for your input. i'm a bit of a noob when it comes to filemaker calculations and summaries. i was under the impression there was a way to possibly modify the get(foundcount) calculation to count records that have certain values in certain fields.

perhaps if i clarify you might get a better understanding... my database keeps track of all the movies a movie theater is playing/has played. on a list layout all of the movies are listed from the movies table, both old and new. a manifest of all the movies entered in to the table, if you will. in the movies table i have a field named 'summary' that's the calculation get(foundcount) which returns the number of records in the table. additionally, in the footer of the list layout, i would like filemaker to return the number of movies that are in the "flat" format, another displaying the number of films in the "scope" format, etc.

could you possible dumb-down your solution for me?

thanks again. i'm trying to learn as best i can!