Sum of two beast mode calculated fields
user080632
⚪️
Can someone please help me with the below scenario:
Where A and B are calculated fields.
I have to show the sum of A and B in the card.
0
Answers

... what have you tried?
sum(a) + sum(b)
what's the problem?
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 
I think the issue here is that you can't name a beastmode from within another beastmode.
For example, if A in this case was something like:
Current Year Sales:
sum(case when `year`=year(curdate()) then `sales` else 0 end)
and B were something like:
Current Year Expenses:
sum(case when `year`=year(curdate()) then `expenses` else 0 end)
You cannot write a third calculated field for profit like this:
sum(`Current Year Sales`)  sum(`Current Year Expenses`)
You would need to write out each calculation:
sum(case when `year`=year(curdate()) then `sales` else 0 end)  sum(case when `year`=year(curdate()) then `expenses` else 0 end)
Hope that helps
______________________________________________________________________________________________
“There is a superhero in all of us, we just need the courage to put on the cape.” Superman
______________________________________________________________________________________________1 
Thank you.
It worked when I wrote out each calculation.
1
Categories
 11.3K All Categories
 6 Private Company Board
 2 APAC User Group
 12 Welcome
 45 Domo News
 10.2K Using Domo
 2K Dataflows
 2.6K Card Building
 2.3K Ideas Exchange
 1.2K Connectors
 354 Workbench
 271 Domo Best Practices
 13 Domo Certification
 482 Domo Developer
 58 Domo Everywhere
 112 Apps
 734 New to Domo
 86 Dojo
 Domopalooza
 1.1K 日本支部
 4 道場日本支部へようこそ
 31 お知らせ
 65 Kowaza
 305 仲間に相談
 667 ひらめき共有