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 heart 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
 10.6K All Categories
 1 APAC User Group
 12 Welcome
 36 Domo News
 9.6K Using Domo
 1.9K Dataflows
 2.4K Card Building
 2.2K Ideas Exchange
 1.2K Connectors
 339 Workbench
 252 Domo Best Practices
 11 Domo Certification
 461 Domo Developer
 47 Domo Everywhere
 100 Apps
 703 New to Domo
 84 Dojo
 Domopalooza
 1.1K ζ₯ζ¬ζ―ι¨
 4 ιε ΄ζ₯ζ¬ζ―ι¨γΈγγγγ
 22 γη₯γγ
 63 Kowaza
 296 δ»²ιγ«ηΈθ«
 649 γ²γγγε ±ζ