Best way to format currency in Charts

Question

I’d like to truncate the currency totals in my charts to round to the thousands and then if its in the millions switch from K to M.

What would be the best way to do this in Charts and Rich Text Components?

Bill_McCullough · Answer

Sam,You can do this with Model UI Formula fields.  You can format the totals and then use an IF statement to choose when to show one or the other.  Here is a page that demonstrates this:                        models.loaded                    ROUND({{{sumAmount}}})                    “$” + VALUE(ROUND({{sumAmount}}/1000)) + " K"                    “$” + VALUE(ROUND({{sumAmount}}/1000000)) + " M"                    IF({{sumAmount}}/1000000&gt;=1,{{TotalMillions}},{{TotalThousands}})                {{Model.labelPlural}}                Home                                    &lt;p&gt;&lt;span style=“font-size:28px;”&gt;&lt;span style=“color:#ffffff;”&gt;Opportunity Total Amount&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style=“font-size:28px;”&gt;&lt;span style=“color:#ffffff;”&gt;Default: {{sumAmount}}&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style=“font-size:28px;”&gt;&lt;span style=“color:#ffffff;”&gt;K: {{TotalThousands}}&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style=“font-size:28px;”&gt;&lt;span style=“color:#ffffff;”&gt;M: {{TotalMillions}}&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style=“font-size:28px;”&gt;&lt;span style=“color:#ffffff;”&gt;S: {{SwitchFormat}}&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;sum                                         &n

View our Community Site Map

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded