ignore NULL values when collecting data