filling NULL values created as a result of the generation of field value combinations
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])
Re: filling NULL values created as a result of the generation of field value combinations
I added it into the script but it didn't work. Is there any specific place i should put it at? Also the column is not actually null in the first place. The reason why the column is null in the table is because the key between the 2 tables in the database do not match sometimes.