How to display thousands separators and decimals in the Italian format?

Questions & Answers
1

Hello everyone, I am trying to understand how to display the separator of thousands and decimals in the Italian format. Currently the comma is used to separate the thousands. I am using a “measure” that calculates the number of working days from the total number of hours divided by “8”.

Screenshot 2024-04-09 alle 10.14.15

2

Hi @kalos

I see that you already found a Community post referencing custom locales: Number format from 1,234.56 to 1.234,56 - #2 by gerda.grantina

In the documentation page, you’ll find that you can create your own custom locales file: Custom locales

ChatGPT returned the following possible settings for Italian locale:

it:
  locales:
    xx: "Ora Italiana"

xx:
  cubes:
    dimensions:
      Time:
        caption: "Tempo"
        all_member_caption: "Tutto il Tempo"
        Year:
          caption: "Anno"
          member_format: "%Y"
        Quarter:
          caption: "Trimestre"
          member_format: "T%{key} %Y"
        Month:
          caption: "Mese"
          member_format: "%Y/%m"
        Day:
          caption: "Giorno"
          member_format: "%d/%m/%Y"
        Weekly:
          caption: "Settimanale"
          all_member_caption: "Tutto il Tempo (settimanale)"
          Year:
            caption: "Anno"
            member_format: "%Y"
          Week:
            caption: "Settimana"
            member_format: "S%{key}, %d/%m/%Y"
          Day:
            caption: "Giorno"
            member_format: "%d/%m/%Y"
        Fiscal:
          all_member_caption: "Tutti i periodi fiscali"
          caption: "Fiscale"
          Year:
            caption: "Anno"
            member_format: "EF%{key}"
          Quarter:
            caption: "Trimestre"
            member_format: "EF%{parent_key} T%{key}"
          Month:
            caption: "Mese"
            member_format: "EF%Y/%m"
          Day:
            caption: "Giorno"
            member_format: "%d/%m/%Y"
        "2 Weeks":
          caption: "Bi-settimanale"
          all_member_caption: "Tutto il Tempo (bi-settimanale)"
          Year:
            caption: "Anno"
            member_format: "%Y"
          Weeks:
            caption: "Settimane"
            member_format: "S%{key}, %d/%m/%Y"
          Day:
            caption: "Giorno"
            member_format: "%d/%m/%Y"

  date:
    formats:
      default: "%Y-%m-%d"
      long: "%d %B %Y"
      short: "%d %b %Y"
      month_year: "%B %Y"
      month_year_short: "%b %Y"
      month_day_short: "%d %b"

  time:
    formats:
      default: "%a, %d %b %Y %H:%M:%S %z"
      long: "%d %B %Y %H:%M:%S"
      short: "%d %b %Y %H:%M:%S"

  number:
    format:
      delimiter: "."
      precision: 2
      separator: ","
      significant: false
      strip_insignificant_zeros: false

Please, double-check before implementing.
I hope that this leads to the right direction!
​Best regards,
​Nauris

1 Like