Having trouble with creating calculated items within a report
Summary
Grouping by Count is not calculating correctlyContent
Hi. I am trying to create groups of employee ages (i.e. 18-24, 25-34, etc.) by creating a new calculated item. I have created groups using the Count function but it isn't calculating correctly. For example, we have over 700 employees that fall in the 18-24 age group but the report counts 138 for that group. What am I missing?
These are the steps I have taken:
1. Create New Calculated Item
2. Display Label = the age group (i.e. 18-24)
3. Values From = Worker.Age (a calculated field I created)
4. Function = Count
5. Select all ages that fall in that group
Tagged:
0