Solved

Conditional Formatting millions

  • 8 June 2021
  • 6 replies
  • 79 views

https://help.looker.com/hc/en-us/articles/360023573694-Conditional-Formating-using-Table-Calculations

 

Used the article above to create indicators but now I can’t format to millions of $USD. Any ideas here? I have my value rounded but would like to add commas and $ symbol.

icon

Best answer by Dawid 9 June 2021, 19:46

Can you show what you’re using? Also you didn’t specify commas for what? the decimal point or as a thousand delimiter?

View original

6 replies

Userlevel 6
Badge +1

What kind of output are you looking for? If you use $0.00,,"M" that would display the values in millions

From:

To:

 

not quite - but thanks for the reply @Dawid ! I used the solution in the link to get the following result - but I would like to change the format of these to have commas, and a dollar sign.  I know I can concat the dollar sign and when I try to use the advanced formatting option it doesn’t update the value

 

Userlevel 6
Badge +1

Can you show what you’re using? Also you didn’t specify commas for what? the decimal point or as a thousand delimiter?

Yes the latter, I would like to add in commas as the thousands delimiter. I suppose there is some syntax I can find for that. Thanks!

Userlevel 6
Badge +1

You might need to do some conditional formatting like this:

 

[>=10000000]$ ###,###,##0.00;[>=100000]$ ###,###,##0.00;$ ###,##0.00

 

Even though it doesn’t work fully but probably need to go in that direction to replicate the thousand separation for millions

@Crystal_Taren are you inserting that green check with the `html` parameter for the field? that doesn’t follow the same rules or show up in the same places as the `value_format` parameter for the field.

Reply