06-16-2020 07:28 AM
4/11/2018
I have a data source with spaces instead of commas as the thousands separator. I have tried the following to no avail:
Put |Space| in the thousands separator field in the amount column of the data source
Use the substitution settings to find/replace the space with either nothing or a comma
Use a complex expression to manipulate the amount
Anybody got any ideas to try to run into this before?
06-26-2020 10:25 AM
Dim amount As Decimal = args.Value.Replace("" "", String.Empty).xfconverttodecimal
If IsNumeric(amount) Then
api.ValueIsnumeric = True
Return amount
End If