Decimal/Thousands Character

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 ✓

    This can be changed in company settings within the admin.

Answers

  • michiko
    michiko Contributor

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

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

    Result

  • Jones01
    Jones01 Contributor

    @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 ✓

    This can be changed in company settings within the admin.

  • 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

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