Display Decimal Places
I was wondering if anyone had a solution for this...
I hvae a field I built in Beast Mode that has this CASE logic...
(CASE
WHEN `cost` IS NULL THEN 'n/a'
ELSE CONCAT('$',ROUND(`Cost`,0))
END)
When i try and put 2 in for the round places and if the value does not have any decimal places to strat with in the raw data it will not add those two decimnal places. How do I force two decial places via Beat Mode for all numbers regardless if the original source data has 0, 1, 2, 3, etc decimal places
Best Answer
-
A solution might be:
CASE WHEN 'cost' IS NULL THEN 0
ELSE 'cost'
ENDIt will have a 0 rather than 'n/a' which may not work for you, but this would allow you to choose the format of these values as currency and choose to have 2 decimal places.
My thinking is that having 'n/a' or a concatenated value with '$' turns every value into a text string rather than a number which doesn't allow you to format as currency or choose the decimals needed.
Let me know if this works for you!
0
Answers
-
A solution might be:
CASE WHEN 'cost' IS NULL THEN 0
ELSE 'cost'
ENDIt will have a 0 rather than 'n/a' which may not work for you, but this would allow you to choose the format of these values as currency and choose to have 2 decimal places.
My thinking is that having 'n/a' or a concatenated value with '$' turns every value into a text string rather than a number which doesn't allow you to format as currency or choose the decimals needed.
Let me know if this works for you!
0
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.2K Connectors
- 284 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.9K Transform
- 89 SQL DataFlows
- 556 Datasets
- 2.2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 569 Beast Mode
- 10 App Studio
- 27 Variables
- 578 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 23 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 350 Distribute
- 90 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive