1 Reply Latest reply on Jul 2, 2013 2:14 AM by Dana Withers

    Replace Black/Null with Zero

    Bhujang Hundre

      Hi all,

       

      I am looking forward for help. I want to replace blank with zero. i alread used ZN formula but its not working

       

      Please find the attached work book.

       

      Regards

      Bhujang

        • 1. Re: Replace Black/Null with Zero
          Dana Withers

          Hi Bhujang,

           

          I'm not sure that what you want is possible. Technically, you're not getting any blanks, so the zn function doesn't work. You're "missing" information, which is not the same as getting "blank" information.

          What I mean is that there is no connection between Mexico and Competitor A in your dataset, I don't think there is a function that can create that data. What you can do, is create a count competitor field that counts for each record all the As, Bs, Cs etc and then put those measures in the text table.

           

          Does that help?

           

          Dana