I uploaded my Excel document and it has numbers (as text; I'm not doing sums, etc.). Some of the cells have 'Not Available'. I can't figure out how to say "If the population count is 'not available' then put 'not available' in the cell. Otherwise input whatever is in the population count cell in the Excel doc.
Here's what I tried. It did not work though (error during data load script)
If ("PopulationCount" = 'Not Available', 'Not Available', "PopulationCount")
Hmm, the 'as' turned red and the second part of the clause was pinked out (both for 'error').
I added an ')' at the end but it did not do the trick.
Alt(Num([PopulationCount],'Not Available') as [PopulationCount])