Displaying information in Cents ad Dollars

[fpereira]

Hi Looker community,

I have a dataset displaying number values  (i.e.: 123456). Each value represents cents and I would like to display these as dollars (i.e.: $1,234.56). I want to do so through the custom formatting in the visualization or through the formatting available in custom dimension/measure settings. I would like to avoid going into the developer mode and coding the format in the explore.

So far, I got to format the display as $1234.56 by using the format “$#0\.00”, but when I try to do “$#,###0\.00” the formatting  goes away completely.

Could anyone help me adjusting this format?

Thank you.

[Dawid]

Try this: #,###.00  without escaping the dot or $#,##0.00 if you want to make sure one zero gets shown.

But also try value_format_name: usd  as it may already do what you want to do:

https://docs.looker.com/reference/field-params/value_format_name