Sum of two beast mode calculated fields

user080632 · March 2021

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.

jaeW_at_Onyx · March 2021

... what have you tried?

sum(a) + sum(b)

what's the problem?

ST_Superman · March 2021

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

user080632 · March 2021

Thank you.

It worked when I wrote out each calculation.

Charting