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.
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