Question

Value Format Name validation issue

  • 29 June 2021
  • 1 reply
  • 39 views

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:

 

Am I missing something?

Thanks,

Mihaela


1 reply

Userlevel 6
Badge +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

Reply