Case ( calc_age ≤ 18 ; "Group A" ;
calc_age ≤ 29 ; "Group B" ;
calc_age ≤ 39 ; "Group C" ;
Fantastic..... Thanks a lot! Just what i needed!!
That depends on the structure of your database. I'd use another approach.
If you sort your records by the value returned by our Case function here, we can use a summary field with the "count of" option to count the records in each group. You'd do so by adding a sub summary part "when sorted by" this calculation field to your layout and then you put the summary field inside this sub summary part. As long as you sort your records by the Age group calculation field, you'll see the counts for each group of records. You can include the list of individual records in the body of your layout or you can remove the body of the layout and just list the age groups with their counts on this layout.
It's also possible to use a "self join" a relationship that links a table to itself, linking by this age group field and then the same summary field or a calculation field with Count ( RelatedTableOccurrence::SomeNeverEmptyField ) can be used to count the records in each age group.
A secondary table with one record for each age group can also be used with a relationship that matches by age group to count records using the same summary field or Calculation field with Count ( ) to count the records in each group.