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.
Answered Dec 15, 2019 · 1.2K Views Read answer →