Decimal/Thousands Character

Options
Jones01
Jones01 Contributor
edited May 2023 in Charting

Hi,

We have clients in Europe where the decimal point that separates the whole number from its fractional parts is a comma instead of the usual period/dot(.).

Is there anyway to change this?

So in the UK the number 28586.84 would be 28,586.84 but in Europe that would be 28.586,84

Thanks

Best Answer

  • Jones01
    Jones01 Contributor
    Answer ✓
    Options

    This can be changed in company settings within the admin.

    image.png

Answers

  • michiko
    michiko Contributor
    Options

    Are you trying to show 28.586,84 as 28,586.84 ?? 🤔

    Cheap Trick: cast(replace(replace(europe, '.', ''), ',', '.') as double)

    image.png

    Result

    image.png

  • Jones01
    Jones01 Contributor
    Options

    @michiko

    Yes but the other way so Uk to Europe.

    28,586.84 to 28.586,84

    Thanks for the tip. I am waiting to hear from domo whether this can be something set on the instance.

  • Jones01
    Jones01 Contributor
    Answer ✓
    Options

    This can be changed in company settings within the admin.

    image.png

  • GrantSmith
    GrantSmith Coach
    Options

    The company settings - language setting may allow you to change the display type of numbers for the entire instance by selecting your variation of English.

    I wouldn't use a formula in the ETL to do the conversion as it will convert it to a string instead of a number and you'd lose all of the numerical aggregations. You may be able to do it in a beast mode but you'd need to conditionally know who is looking at it to set the correct format.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • Jones01
    Jones01 Contributor
    Options

    @GrantSmith thanks. Yes feature seems to work although I need Greek so hoping it is easy for domo to add new formats.

Categories