Calculating percentage of items

[faithhay]

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.

[-Queue-]

One way to do it, if you also want to be able to view the results in browse mode, is to create a self-relationship based on the text field, then create a calculation number field of Count(relationship::serial) / Status(CurrentRecordCount).

[faithhay]

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.