Skip to content

    • Charting

    Charting

    Decimal/Thousands Character

    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

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Best Answer

    • Contributor
      Answer ✓

      This can be changed in company settings within the admin.

      image.png

    Answers

    • Contributor

      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
    • 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.

    • Contributor
      Answer ✓

      This can be changed in company settings within the admin.

      image.png
    • Coach

      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!**
    • Contributor

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

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories