Hi,

I have a data sheet with several values including age. From that data I have created groups/variables according to age. When I open a group for a specific age set, the data for each person with the specified age is contained in the file. However the persons excluded from the data due to unwanted age in the specific file is left as dots. This means that when calculating using a set based on age it counts every person from the data set and not just the chosen age. Numbers are correct but the count is wrong as in 100 persons in the data set but only 35 for the specific age. So when doing a summarize the count isn't 35 but 100.

What can I do to remove the unwanted data displayed as dots in my variables?