Jump to content

formula


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

Recommended Posts

Sounds like you want to do a Summary report.

Create a new layout by selecting New Layout/Report under Layouts in the Menu Bar. Select Columnar List/Report as your layout type, and just follow the instructions for how to divide up your summaries.

Also, you'll want to create 1 summary field to get the Count Of a field you know will never be empty (auto-enter serial #).

Try this out and see if it makes sense. Let us know if you get stuck.

Link to comment
Share on other sites

cCountAge is the name of the calculation field which formula is: Count ( SJ_age::PersonID )

This is basically the count of all the PersonIDs based off the 'self joining' relationship that I called SJ_age. Take a look at the relationships graph.

The self joins are based off of the value of the current record and then the count function counts all records that match the value of the current match field. In other words, if the current record has the value of 5 in the age field, the self join matches all records that have the value 5 in it. Then the calcuation counts the number of records that has 5 for the age in it.

Link to comment
Share on other sites

This topic is 5746 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.