Forum Discussion

OSAdmin's avatar
OSAdmin
Icon for OneStream Employee rankOneStream Employee
6 years ago

I have a data source with spaces instead of commas as the thousands separator.

Originally posted by Jon Golembiewski

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?

Data Sources

1 Reply

  • OSAdmin's avatar
    OSAdmin
    Icon for OneStream Employee rankOneStream Employee
    6 years ago
    Originally posted by Nick Kroppe

    Dim amount As Decimal = args.Value.Replace("" "", String.Empty).xfconverttodecimal
    If IsNumeric(amount) Then
    api.ValueIsnumeric = True
    Return amount
    End If