Adding Columns in Calculator and losing values

Reply
Highlighted
White Belt

Adding Columns in Calculator and losing values

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.

 

 


Accepted Solutions
Highlighted
Red Belt

Re: Adding Columns in Calculator and losing values

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.




**Make sure to like any users posts that helped you and accept the ones who solved your issue.**

View solution in original post

Tags (2)

All Replies
Highlighted
Red Belt

Re: Adding Columns in Calculator and losing values

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.




**Make sure to like any users posts that helped you and accept the ones who solved your issue.**

View solution in original post

Tags (2)
Highlighted
White Belt

Re: Adding Columns in Calculator and losing values

Worked like a charm, thank you!

Announcements
Win free lodging at Domoapalooza! We want you to share you favorite Domo tips and tricks. Click here for more details!