Jump to content

Summary Calculation


Yonal
 Share

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

Recommended Posts

  • Newbies

Dear friends,

I just very new in File Maker. Recently, i created a database contains bio data of students in our schools. It was around 6000 entry/student in the records. NOw, i got desperate when i need to count how many such as: male/female students, students with theirs tribes, and religion. For example: in my "Religion" field table contains entry: Islam, Buddha, Christian, Animist. How could i summarize how many are Islam, Buddha, Christian, Animist, etc.

Thanks in advance for your kindness

Yonal

Link to comment
Share on other sites

  • Newbies

Forgive me to ask more:

1. How to count the grand total, sub total for every field?

2. Is there any formula to count "length of service" which result year and month. For example: hire date: Sep 3rd, 2000. Length of service= 10 years, 4 months.

Thanks,

Link to comment
Share on other sites

1. You need a summary field that is the count of a unique value, typically the record's primary key: cnt_Records = Count (RecordID), type summary. If you place this field in a sub-summary part, you will get a subtotal by the break field defined in the sub-summary part. Place this field in the Trailing Grand Summary part, and you get a Grand Total.

2. See Custom Function Age

Link to comment
Share on other sites

This topic is 4389 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
 Share

×
×
  • Create New...

Important Information

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