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