Skip to Content
0
Jan 10, 2023 at 12:58 PM

Getting #ERROR while turning a String filed into Numeric with Blank Values

138 Views Last edit Jan 09, 2023 at 11:00 PM 2 rev

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])