09-01-2023 05:31 AM
Hi
Is it possible to treat a dash/hyphen as a zero during a data import from a file?
Thanks,
Mark
09-01-2023 09:06 AM
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.
09-04-2023 04:49 AM
Thanks Eric, I'll give that a try.
My only concern is that it may cause an issue with negative values?
09-04-2023 10:30 AM - edited 09-04-2023 10:33 AM
Delete original post
09-07-2023 02:56 PM
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