Value Format Name validation issue

Hi,

I have added a named_value_format in my model:

named_value_format: gbp_with_comma {
  value_format: "\"£\"#,##0" #
}

 In view:

 measure: actuals {
          type: number
          value_format_name: gbp_with_comma

  }

I get the following validation error:

There are some issues with this LookML code that will cause aspects of your data model to behave unexpectedly. These should be repaired to ensure your data model works as intended.

No value format named "gbp_with_comma" is defined. Must be one of "decimal_0", "decimal_1", "decimal_2", "decimal_3", "decimal_4", "eur", "eur_0", "gbp", "gbp_0", "id", "percent_0", "percent_1", "percent_2", "percent_3", "percent_4", "usd", "usd_0"

Same thing if I use value_format_name: “gbp_with_comma”.

In the explore I can see this format:

c85cd336-e422-41dd-b619-55fd05abd6fc.png

Am I missing something?

Thanks,

Mihaela

2 1 262
1 REPLY 1

I checked it on my side and added a test value format and I can confirm the LookML Validator throws errors even though the value format is clearly present in the model

Top Labels in this Space
Top Solution Authors