Hello,
I created a value format to simplify large numbers, but i needed to use localization so i used HTML as well to be able to translate the string millions to milliard in french. Example: EN 21.16 B€, FR 21.16 Mds€
Nevertheless, when i display the values in a graphic, it only shows the value format without the text. Example: 21.16
Here ir my lookml code:
named_value_format: eur_formatting {
value_format: "[>=1000000000]\"\"#,##0.00,,,\" \";[>=1000000]\"\"#,##0.00,,\" \";[>=1000]\"\"#,##0.00,\" \";\"\"#,##0.00"
strict_value_format: yes
}
measure: commitment_m {
label: "total_commitment"
type: sum
value_format_name: eur_formatting
sql:${commitment} ;;
html:
{%if value >=1000000000 %}
{{rendered_value}}{{_localization["B"]}}€
{%elsif value >=1000000 %}
{{rendered_value}}{{_localization["M"]}}€
{%elsif value >=1000 %}
{{rendered_value}}{{_localization["K"]}}€
{% else %}
{{rendered_value}}€
{% endif %}
;;
}