Hi,
I'm having difficulty getting the structure of this type of report straight. I have a report with empid, name, age, gender and need to summarize the data as in the following example.
Age Count %
18-33 211 33.7
34-50 339 54.1
51-78 77 12.3
----- -----
627 100.0
Average Age
628 Employees : 38.41
471 Women : 38.44
156 Men : 38.31
I've created formulas using "Age In 18 To 33" etc... and am grouping on the age range formulas. However, this isn't working cleanly. Is there a better way?
Thanks,
Q
I'm having difficulty getting the structure of this type of report straight. I have a report with empid, name, age, gender and need to summarize the data as in the following example.
Age Count %
18-33 211 33.7
34-50 339 54.1
51-78 77 12.3
----- -----
627 100.0
Average Age
628 Employees : 38.41
471 Women : 38.44
156 Men : 38.31
I've created formulas using "Age In 18 To 33" etc... and am grouping on the age range formulas. However, this isn't working cleanly. Is there a better way?
Thanks,
Q