Simple Addition and Subtraction
Hi There, I am having trouble in returning correct values with a simple addition and
subtraction beast mode. It appears that any column with a blank value will not return a end value. And any row with values in all columns calculates properly. Any suggestions on how to calculate to consider blank values as zero value? Thanks
Beast mode calculation formula:
End Future Stock Balance:
`Total Stock`+`Total QTY to be delivered``Total fcst QTY``Total Reqmt QTY`
Best Answer

@Emma the IFNULL function is also useful for this and does the same thing. COALESCE is useful when you need to evaluate multiple fields before replacing with a single value. Here is what yours would look like with the IFNULL function:
IFNULL(`Total Stock`,0)+IFNULL(`Total QTY to be delivered`,0)IFNULL(`Total fcst QTY`,0)IFNULL(`Total Reqmt QTY`,0)
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.2
Answers

Hi @Emma
You can use the COALESCE function to default a null value to a specific value. It does this by selecting the first nonnull value in the list of parameters given
COALESCE(`Total Stock`,0)+COALESCE(`Total QTY to be delivered`,0)COALESCE(`Total fcst QTY`,0)COALESCE(`Total Reqmt QTY`,0)
If you use simple arithmetic operators (+, , *, /) with a null the end result is null because it doesn't know how to handle nulls.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**3 
Thank you @GrantSmith . You are wonderful, in all my google searches, this solution did not come up.
Best wishes for a lovely holiday.
0 
Glad this worked for you @Emma. Can you make sure to accept the answer so it's easier for others to find in the future? Thanks.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**3
Categories
 11K All Categories
 5 Private Company Board
 2 APAC User Group
 12 Welcome
 42 Domo News
 9.9K Using Domo
 2K Dataflows
 2.5K Card Building
 2.2K Ideas Exchange
 1.2K Connectors
 349 Workbench
 267 Domo Best Practices
 11 Domo Certification
 474 Domo Developer
 51 Domo Everywhere
 110 Apps
 725 New to Domo
 85 Dojo
 Domopalooza
 1.1K 日本支部
 4 道場日本支部へようこそ
 29 お知らせ
 65 Kowaza
 301 仲間に相談
 662 ひらめき共有