Displaying information in Cents ad Dollars

Looker Q&A Career & Social
1

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.

2

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