10 Replies Latest reply: Sep 7, 2017 9:31 PM by Chan HS RSS

    filling NULL values created as a result of the generation of field value combinations

    Chan HS

      Hi,

       

      As the question says, I have a table that has null values due to the field values not matching up. I want to fill the empty fields with something else. As the actual data in the fields are not null, I believe I should be doing this in the expression. The formula I used is

       

      if (isnull ([Country]), 'Rest of the world', [Country])

       

       

      However, it is not working. How should I do this?