Assuming Eviction column is numerical and you are calculating eviction rate, so you might be adding the values of Eviction column and dividing it by some other value. I think in that case create a calculated field say "Eviction_new"
If [Eviction] = Null Then 0 Else [Eviction] End
This will create a new field Eviction_new and will replace Null by 0 and keep other values as it is.
Yes Shin! this is it. Thank you so much!
You are very welcome.