1 Reply Latest reply on Mar 20, 2016 2:57 PM by Sharad Adhikari

    Replace null value with zero.

    Bhavesh Jain

      Hi Experts,

       

      As per my requirement i need to replace all Null values in a line chart with zero for last 24 months data.

       

      But in below conditions I am not able to do the same. I was able to replace Null with zero for dates in between but not for dates at the beginning.

      Please help me.

       

      TWBX file attached.

       

      Best Regards,

      Bhavesh

        • 1. Re: Replace null value with zero.
          Sharad Adhikari

          Hi,

           

          I did open the tbwx file and wondered few things. Why are you focusing to change the null values for the last 24 months only? I guess it would be straightforward to change the whole sales null data to zero with ZN formula.

           

          I would also suggest to use relative date filter inbuilt inside Tableau desktop for dynamic last 24 months case.

           

          Could you elaborae what do you mean " I was able to replace Null with zero for dates in between but not for dates at the beginning"?

           

          BR

          Sharad