# Can I have 2 numbers (% and absolute value) in the summary number section of a card?

edited March 2023 in Datasets

I am looking for a way to have 2 numbers in the summary number section (% and absolute value). How can I display both?

Thanks,

Celine

• Coach

Hi @CelineH,

There is a way to do that through a Beastmode. Basically you will need to create a formula concatenating the folowwing things:

CONCAT(

(FormulaForThePercentage),

'% sign plus the name you give your calculation',

(FormulaForTheAbsoluteValue),

ones you create your beastmode make sure to check the box "Apply to Summary Number" and save.

https://dojo.domo.com/t5/Domo-Dojo-Contest-January-2016/quot-Best-Beast-Mode-Formula-quot/idi-p/7840

This is an example , a formula I currently use. hope it helps you

CONCAT(FLOOR(
(SUM(CASE
/
SUM(CASE
,'% Quarterly ',
FLOOR(
(SUM(CASE
/
SUM(CASE
,'% Annually')

Domo Arigato!

**Say 'Thanks' by clicking the thumbs up in the post that helped you.
• Contributor
Add a ROUND(XXXX , 4) to the equation. CONCAT( ROUND((SUM(`Calculation Use 1`)/COUNT(`Phone`)),4)*100,'% Conversion Rate',' ',',', COUNT(`Phone`),' ','Total Leads')
Dojo Community Member
** Please like responses by clicking on the thumbs up

• Coach

Hi @CelineH,

There is a way to do that through a Beastmode. Basically you will need to create a formula concatenating the folowwing things:

CONCAT(

(FormulaForThePercentage),

'% sign plus the name you give your calculation',

(FormulaForTheAbsoluteValue),

ones you create your beastmode make sure to check the box "Apply to Summary Number" and save.

https://dojo.domo.com/t5/Domo-Dojo-Contest-January-2016/quot-Best-Beast-Mode-Formula-quot/idi-p/7840

This is an example , a formula I currently use. hope it helps you

CONCAT(FLOOR(
(SUM(CASE
/
SUM(CASE
,'% Quarterly ',
FLOOR(
(SUM(CASE
/
SUM(CASE
,'% Annually')

Domo Arigato!

**Say 'Thanks' by clicking the thumbs up in the post that helped you.
• Contributor
This works great and we have employed situations like this as well. One item to keep in mind, is if you use this, you cannot get these metrics to appear in your Daily DOMO digest. It will not pick up a concat statement. So weight the tradeoff of one card vs. the auto email update of KPI's. No right answer here - just a tradeoff to consider!
Dojo Community Member
** Please like responses by clicking on the thumbs up
• Contributor

• Yes it finally worked!

thanks!

• Coach
Great! could you mark the answer that was the solution. that would help others who come into this post.
Domo Arigato!

**Say 'Thanks' by clicking the thumbs up in the post that helped you.
• CONCAT(
(SUM(`Calculation Use 1`)/COUNT(`Phone`))*100,'% Conversion Rate',' ',',',

My only concern right now is the %number is super long and i can't manage to get it rounded. Any suggestions?

• Contributor