8 Replies Latest reply on May 16, 2018 9:18 AM by nick liu

    Replacing Null with 0 not working with LOD

    nick liu

      I have one excel that contains the demand data by part number: e.g: the demand for Part a is 10.

       

       

      I have another excel containing the parts supply by part number by Week: e.g: In Week 1, the supply for Part a is 2, and 9 for week 2.

       

       

      then I left joined these two excels with "Part Number":

       

       

       

      In order to show the weekly supply by Part Number, I had a calculated field to use isnull to replace nulls with 0:

       

      {fixed [PartNumber-Demand],[Week]: if isnull(sum([Supply Quantity])) then 0 else sum([Supply Quantity]) end}

       

       

      but the issue remains as the yellow part in the following screenshot still shows as blank.

       

       

      Instead of Using ZN function, is there any other way I could fix this issue?

       

      Appreciate in advance for any great advice!!

       

      Thanks!!

       

      p.s: I attached my tableau file.