Is there a way I can display blanks when a value is zero
I am displaying some financial information in a table card. In a few columns of numeric, most of the values are 0. In Excel, I can display them as "-" (w/o the quotes) which makes it very clear that the value is zero and makes the sheet easier to read. Does Domo have a similar option?
Best Answer
-
Hi,
I think there is no straightforward way of doing that.
You case use the following beast mode in each column, but you will lose DOMO's native ability to format numbers...
Here is the Beast Mode Anyway:
CASE WHEN `Your_Numeric_Field`=0 THEN '-' ELSE CONCAT(`Your_Numeric_Field`,'') END
Hope this helps.
Ricardo Granada
MajorDomo@Lusiaves
**If the post solves your problem, mark it by clicking on "Accept as Solution"
**You can say "Thank you" by clicking the thumbs up in the post that helped you.0
Answers
-
Hi,
I think there is no straightforward way of doing that.
You case use the following beast mode in each column, but you will lose DOMO's native ability to format numbers...
Here is the Beast Mode Anyway:
CASE WHEN `Your_Numeric_Field`=0 THEN '-' ELSE CONCAT(`Your_Numeric_Field`,'') END
Hope this helps.
Ricardo Granada
MajorDomo@Lusiaves
**If the post solves your problem, mark it by clicking on "Accept as Solution"
**You can say "Thank you" by clicking the thumbs up in the post that helped you.0 -
Thanks. Works for some of my cases (where I am not totalling).
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 294 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 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