Adding Columns in Calculator and losing values
![[Deleted User]](https://us.v-cdn.net/6032830/uploads/defaultavatar/nZ5X977MOM3Z6.jpg)
I am adding two columns together in a Calculator function and where one column is blank, the sum is blank despite data in the first column. In other words, as shown below, red plus blue plus black should equal the figure highlighted. I have tried the data set as is (with blanks) as well as with zeroes. Any help would be appreciated.
Best Answer
-
You need to replace the blanks with a zero prior to using the calculator. To do this, insert the value mapper tile and do the following in the steps of the value mapper:
1. Select your column that has the blank values
2. Choose Overwrite values in searched columns
3. Keep the original value
4. Click the wheel cog and select Null value or Empty string depending on what those blanks actually are.
5. Enter 0
You can then link this to your calculator tile and it should add your columns without issue.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.2
Answers
-
You need to replace the blanks with a zero prior to using the calculator. To do this, insert the value mapper tile and do the following in the steps of the value mapper:
1. Select your column that has the blank values
2. Choose Overwrite values in searched columns
3. Keep the original value
4. Click the wheel cog and select Null value or Empty string depending on what those blanks actually are.
5. Enter 0
You can then link this to your calculator tile and it should add your columns without issue.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.2 -
Worked like a charm, thank you!
0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 305 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 111 SQL DataFlows
- 649 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 782 Beast Mode
- 76 App Studio
- 43 Variables
- 738 Automate
- 186 Apps
- 473 APIs & Domo Developer
- 65 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 406 Distribute
- 117 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 138 Manage
- 135 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive