Adjusting a decimal to be used as a summary number
I have a column that calculates a %. in the dataset it reflects like 94.965, 97.245, etc. which works great in any card. Now that I am trying to use it as a summary number I am running in to this issue:
I can't seem to be able to get it to reflect 94.39%. it just shows this big ugly number. This field is a calculated using a beast mode. there is a single column called 'description' that has the name of every metric in the dataset then a correlating column called 'value' that had the value so to only pull of out the SFO the beast mode used is:
((CASE when `Description` like '%Occ % of Total Area%' then `Value` END))
Not sure if this makes an impact on how it shows as a summary number.
Best Answer
-
I was getting the field formatting mixed with the summary number formatting. For whatever reason Domo doesn't have that option on the summary number formatting options. You'll need to have a separate beast mode for your summary number where you divide the final number by 100 and format it as a percentage.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Answers
-
Uncheck the box that says to multiply by 100 and that should resolve your issue
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
@GrantSmith Now the more difficult question is where is that and why can't I see it in the summary number drop down detail?
0 -
I was getting the field formatting mixed with the summary number formatting. For whatever reason Domo doesn't have that option on the summary number formatting options. You'll need to have a separate beast mode for your summary number where you divide the final number by 100 and format it as a percentage.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Categories
- 10.6K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 474 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 478 Datasets
- 214 Visualize
- 259 Beast Mode
- 2.1K Charting
- 12 Variables
- 19 Automate
- 356 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 249 Distribute
- 65 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 191 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive