Not max characters but what is the highest number allowed in a field
Best Answer
-
Domo has maximum number of characters for text fields as 1024, but numerical fields also have limits.
For number and fixed decimal, Domo stores numbers as 64-bit floating point values (ie. Double in most databases). This give high range values, but also precision limits. If your number is large, you may have an issue with the precision or display. The field may be rounding or truncating the number if its too big.
Check the formatting and adjust precision to see it if it resolves the issue.
Also, make sure you aren't using fields that have NULL or empty values. Use coalesce() when appropriate to make null values calculate as 0 if needed.** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0
Answers
-
Domo has maximum number of characters for text fields as 1024, but numerical fields also have limits.
For number and fixed decimal, Domo stores numbers as 64-bit floating point values (ie. Double in most databases). This give high range values, but also precision limits. If your number is large, you may have an issue with the precision or display. The field may be rounding or truncating the number if its too big.
Check the formatting and adjust precision to see it if it resolves the issue.
Also, make sure you aren't using fields that have NULL or empty values. Use coalesce() when appropriate to make null values calculate as 0 if needed.** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 738 Beast Mode
- 56 App Studio
- 40 Variables
- 684 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 46 Workflows
- 10 DomoAI
- 35 Predict
- 14 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 123 Manage
- 120 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive