Sum of two beast mode calculated fields

user080632
user080632
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-_ Coach

    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
  • user080632
    user080632

    Thank you.

    It worked when I wrote out each calculation.

Categories