Data Import: treat a dash a zero

You could through a rule on the Amount field, but in an attempt not to go that route you could try to Substitution settings on the Data Source Amount field. I have not tested this particular situation though.

Perhaps a complex expression in the Amount field of the data source? Off the top of my head, maybe something like this:

If args.Value = "-" Then
	Return 0
Else
	Return args.Value
End If

Thanks Eric, I'll give that a try.

My only concern is that it may cause an issue with negative values?