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.