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.
Solved! Go to Solution.
Can you show what you’re using? Also you didn’t specify commas for what? the decimal point or as a thousand delimiter?
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
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!
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.