Round function
Hello, I have a beast mode that calculates a % and I need it to round to 2 decimals.
I'm using the round function as described in the documentation:
CONCAT(ROUND(1(COUNT(DISTINCT `nc_list`) / COUNT(DISTINCT `lot_number`)),2)*100, '%')
However, the result is being rounded to the whole number
I need it to, using the example above, display 97.91 instead of 98
What am I missing in my beast mode?
Best Answers

You may not even need to round using a beast mode calculation. It seems like you are using a textbox chart, however for have you tried using the single value chart? It is a similar chart, and if you look in Chart Properties>General>Decimal Places, you will be able to select how many decimal places you would like to show.
1 
Hi @MartinB
The display options for the field can handle all of this for you.
You can change your beast mode to be:
1(COUNT(DISTINCT `nc_list`) / COUNT(DISTINCT `lot_number`))
Then click on the Beast mode atop your chart to open the menu and select Data Format > Display as and select Percentage with 2 decimal places. You can then also tell it to multiply by 100.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 
I know i'm late to the party, but @MartinB it's just basic math.
CONCAT(ROUND(1(COUNT(DISTINCT `nc_list`) / COUNT(DISTINCT `lot_number`)),2)*100, '%')
If you have 1/3 ( = .33333333) and you wrap that in round( 2) you'd get .33 so when you multiply by 100 you'd get 33.
if you wanted 33.33 then you do round(4).
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2
Answers

You may not even need to round using a beast mode calculation. It seems like you are using a textbox chart, however for have you tried using the single value chart? It is a similar chart, and if you look in Chart Properties>General>Decimal Places, you will be able to select how many decimal places you would like to show.
1 
Hi @MartinB
The display options for the field can handle all of this for you.
You can change your beast mode to be:
1(COUNT(DISTINCT `nc_list`) / COUNT(DISTINCT `lot_number`))
Then click on the Beast mode atop your chart to open the menu and select Data Format > Display as and select Percentage with 2 decimal places. You can then also tell it to multiply by 100.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 
Thanks @GrantSmith and @user096693 I'll try both approaches ??
0 
0

0

I know i'm late to the party, but @MartinB it's just basic math.
CONCAT(ROUND(1(COUNT(DISTINCT `nc_list`) / COUNT(DISTINCT `lot_number`)),2)*100, '%')
If you have 1/3 ( = .33333333) and you wrap that in round( 2) you'd get .33 so when you multiply by 100 you'd get 33.
if you wanted 33.33 then you do round(4).
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2 
Silly me, this formula made the difference. Thanks @jaeW_at_Onyx
CONCAT(ROUND(1(COUNT(DISTINCT `nc_list`) / COUNT(DISTINCT `lot_number`)),4), '%')
Still, had some trouble when adding strings either at the beginning or the end of the formula pasted above...until this I hit jackpot:
CONCAT('Quality ', CONCAT(ROUND(100*1(COUNT(DISTINCT `nc_list`) / COUNT(DISTINCT `lot_number`)),2), '% FPY'))
Thanks to all, this is the solution I was looking for.
1
Categories
 All Categories
 1.7K Product Ideas
 1.7K Ideas Exchange
 1.5K Connect
 1.2K Connectors
 295 Workbench
 6 Cloud Amplifier
 8 Federated
 2.8K Transform
 97 SQL DataFlows
 608 Datasets
 2.1K Magic ETL
 3.8K Visualize
 2.4K Charting
 710 Beast Mode
 50 App Studio
 39 Variables
 668 Automate
 170 Apps
 446 APIs & Domo Developer
 45 Workflows
 7 DomoAI
 33 Predict
 13 Jupyter Workspaces
 20 R & Python Tiles
 391 Distribute
 111 Domo Everywhere
 274 Scheduled Reports
 6 Software Integrations
 116 Manage
 113 Governance & Security
 Domo Community Gallery
 31 Product Releases
 9 Domo University
 5.3K Community Forums
 40 Getting Started
 30 Community Member Introductions
 103 Community Announcements
 4.8K Archive