1 Reply Latest reply: May 22, 2018 8:12 PM by David Forest RSS

    Changing null values to 1's upon script load

    Joshua Russin

      Hello all,

       

      I have been having some trouble counting items that have been picked when a value is null. It was working until these new updates came around, but I am trying to change the value from null to 1 upon script load. Here is what i am trying so far in the script. The output is still the same. Any ideas to figure this out? In set expression, I tried using the -= '' way, but it is not working either.

       

       

      SCRIPT:

       

      "Exception Code" AS "Exception Code bidf",

      if("Exception Code" = '', 1,"Exception Code") as "Exception Code bidf testing",

      "Warehouse Process Cat. Desc." AS "Warehouse Process Cat. Desc bidf",

       

      OUTPUT:

      Capture.PNG

      **"EXCEPTION CODE" is actually "Exception Code bidf"