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

[#1]

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?

[#2]

Hi,

Missingcount shows the blank fields as 1. A simple if statement after that solved the problem.

Thanks for your help all!