faithhay

Vaughan and SlimJim Thank you for your kind replies. What I'm trying to do is get a percentage of each entry in a text field. For example, I've get a field where people select their interests, using radio buttons, e.g., art, music, fitness. I need the percentage of entries marked art, the percentage marked music, etc. So far, I've gotten to the point where I can get the count of people who have selected their interests CountINTEREST - the summary field that's a count of INTEREST. But when I try to divide it by TotalRecords (as defined above), in order to get the percentage, the answers all come out the same. I don't understand why.

This sounds good, but can you explain it a bit more? I don't know what you mean by self relationship. And what do I substitute in Count(relationship::serial). Should relationship be a field name? I don't understand the syntax of these kinds of things very well. Thanks for your help.

I've made a calculation field as follows: CountFIELD (a summary field that's a count of a text field)/TotRecords where TotRecords is a calculation field = Status(CurrentRecordCount) In a subsummary on FIELD, CountFIELD returns accurate data and TotRecords returns accurate data, but the calculation CountFIELD/TotRecords does not, returning 98.5 each time. Is there a way to make this calculation work? Or is there a workaround to get the same data in a different way? THANKS in advance for your help.

How do I get a count for the total number of records with the same data in a field, in a subsummary? For example, I have a field called Interests, where some people have checked skiing, and others have checked swimming. I'd like a count of the number who have checked skiing and the number who have checked swimming. I've tried Count and Status(CurrentFoundCount) and both returns the total found (which includes skiing and swimming). I just want the count of the items in the subsummary. Thanks.

Is there a built-in function that will return the total number of records? If so, can it be used in calculations? Does it vary when it's used in subsummaries by giving only the total number of records for the subsummary? If so, is there a way to get the total number of records for the whole database, even when the calculation is made within a subsummary?

I have a text field for ages, where specific age ranges are marked (e.g., 7 -17, 18 - 28, 29 - 39, etc.). I now need to calculate the percent of records in each age range. How do I do this? I'm assuming I need to sort and use subsummaries, but what fields do I define that will get me the percent? This should be easy, but I'm not sure how to do it.

I am compiling some questionnaires, and need to calculate the percentage of each item in a value list out of the total number of records. For example, radio buttons for ages: 13 - 17, 18 - 28, 29 - 39, etc., I need to create a script that will calculate the percent of total records for each age grouping. Another example, using checkboxes for interests: outdoors, art, music, fitness, etc., where more than one box may be checked. Again, I need to create a script to calculate the percent of total records for each interest. Also, how do I deal with the "other" items? I'm thinking there must be a relatively easy way to do this, but I don't know how.