Sum of two beast mode calculated fields

user080632
user080632 Member
in Charting

Can someone please help me with the below scenario:


image.png

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 Coach

    ... 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"
  • ST_Superman
    ST_Superman Domo Employee

    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 Member

    Thank you.

    It worked when I wrote out each calculation.

Categories