Formatting Summary Number For A Calculation

IDomoDeLaRosa · 2023-09-08T16:32:37+00:00

There was an error rendering this rich post.

Hello All,

I'm struggling here as I feel like I'm so close. I'm trying to show a summary number that is a calculation

(Cost/Leads) and while I've been able to figure out the font size and color, I am still struggling to control the format to be a currency without decimals instead of the number its at now

Right now, I've gotten to this

CONCAT('

',SUM(Cost) / SUM(Leads),'')

Can someone give me an example of where I might be missing something?

Find more posts tagged with

Formatting

Custom

Beast Mode

Accepted answers

MarkSnodgrass

You need to move your closed span tag to be after your numbers. Should look like this:

CONCAT('<span style="color: ##004387; font-size: 32px; font-weight: bold;">$', ROUND(SUM(Cost) / SUM(Leads), 0), '</span>')

All comments

GrantSmith

You'd need a ROUND function to reduce the amount of decimal places. Once you're adding in the HTML coding the data becomes a string and you're unable to utilize Domo's built-in formatting options so you need to format your number yourself. If you want to format it as a currency you can do something like this post:

https://community-forums.domo.com/main/discussion/52677/domo-ideas-conference-beast-modes-number-formatting

IDomoDeLaRosa

Following up, of course, magically after posting here, I figured it out. Ended up with this

CONCAT('

$', ROUND(SUM(Cost) / SUM(Leads), 0), '')

Now I just have to figure out how to make the Title of the Summary Number larger!

ColemenWilson

You can use: '<strong>' & '</strong>' in your beastmode around the part of the summary number you'd like to be more pronounced.

You can also use: '<font size="+3">'

MarkSnodgrass

You need to move your closed span tag to be after your numbers. Should look like this:

CONCAT('<span style="color: ##004387; font-size: 32px; font-weight: bold;">$', ROUND(SUM(Cost) / SUM(Leads), 0), '</span>')