Sum of two beast mode calculated fields

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.

Answers

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟀

    ... what have you tried?

    sum(a) + sum(b)


    what's the problem?

  • 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
    user080632 βšͺ️

    Thank you.

    It worked when I wrote out each calculation.