There are some products that have a value of zero for all day so I want to create a calculation field to remove all those products that contain a NULL value for all days

You can create calculated fields like-

IF ISNULL(field_name) THEN ‘Can be removed’

ELSE [field_name]

END

This will club all the NULL fields in ‘can be removed’ and leave the others as it is.