2 Replies Latest reply: Jan 5, 2017 10:49 AM by Vineeth Pujari RSS

    How to use Null value in set analysis?

    Chris Cools

      Hello,

       

      i'm trying to make an overview of all the SKU's created in our system, but missing a certain field "ProductCollectionCode".

      And i'm trying to do it like this:

       

      Count ( { $<[ProductStatus]={'Active'}, ProductCollectionCode = {''}  >}               SkuCode)

       

      But i don't get any results and i'm sure that there are.

       

      I'm also sure that the expression works because i get results  if i do fill in a collection code like this:

      Count ( { $<[ProductStatus]={'Active'}, ProductCollectionCode = {'2017 Summer'}  >}               SkuCode)

       

      So it must be that the NULL value is causing the expression not to work.

       

      Any ideas how i might have a workaround in the expression without changing Null values in the script?

      (The load scripts are made by an external company, which means it's costly to adapt, it takes time AND i have

      a lot of these empty fields in our masterdata that i would like to work with)

       

      Thanx for your help!!

       

      grtz,

       

      Chris