Round to Millions in Column
Hi,
I want to round currency to millions ("$1,500,000" becomes "$1.5M") for a column in a table that I am replicating from Tableau. The results in Tableau look to have just shifted the decimal point instead of rounding. Below I show regular rounding in blue and the Tableau results in green. Can someone advise how I can do both the blue version and the green version in Domo?
Thank you for your input,
Angela
Best Answer
-
Hi @AJ2020
Here's a link to how I've done textual abbreviations via a BeastMode. https://dojo.domo.com/t5/Card-Building/Textbox-formatting-using-Concat/m-p/50397/highlight/true#M7284
You'll want the bottom example.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Answers
-
Angela, we can't tell you how Domo works, but you can maybe be more specific about what you want the ROUND functionality to do.
mathematically 2.273 SHOULD round up to 2.3. if you always want to round down take a look at the FLOOR() versus the CEILING() implementations for ROUND.
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"1 -
Thank you @jaeW_at_Onyx ?
I have confirmed with management and they want to do traditional rounding (the blue version).
I have seen beast modes that add commas to large numbers, but not for reducing a large number to the shorter notation with the "M" or "B" at the end. I tried the ROUND function with a negative number but that did shorten the digits.
How can I get "$1,499,999" to shorten to "$1.5M" in the column?
Thanks, Angela
0 -
Hi @AJ2020
Here's a link to how I've done textual abbreviations via a BeastMode. https://dojo.domo.com/t5/Card-Building/Textbox-formatting-using-Concat/m-p/50397/highlight/true#M7284
You'll want the bottom example.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
@GrantSmith it worked!
Thanks so much!
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive