Hello,
Using ToNumber function I'm trying convert a String type field to a Numeric field. Some of the rows have blanks and those give me #Errors. I am trying to get a IfNull function to work so if there are blank rows aka null values in the row the function will replace that with a 0.
The function I am using is below:
=If IsNull(ToNumber([Dimension_Field])) Then 0 Else ToNumber([Dimension_Field])