Beast Mode Calculated Field

user00530
user00530
in Dataflows

I have the P&L file upload from QB to Domo in the attached format. I want to calculate the GP which is Income-Expense. How can i do this in beast mode?

Best Answers

  • Artlyfestyle
    Artlyfestyle
    Answer ✓

    Hi there!

     

    You would need to use the following beast mode calculation:

    SUM(Case When `Group Name` = 'Income' then `Value` End) - SUM(Case When `Group Name` = 'Expense' then `Value` End)

     

    Best,

    Joanna

  • PodiumMason
    PodiumMason 🟢
    Answer ✓

    Hey @user00530,

     

    You could do a beast mode:

     

    SUM(Case when `Group Name` = 'Income' then `Amount` else 0 END) 

    -

    SUM(Case when `Group Name` = 'Expense' then `Amount` else 0 END)

     

    Best of luck!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'

Answers

  • DaniBoy
    DaniBoy

    domo

    💎

    @user00530,

     

    If the replies were helpful, please click on "Accept as Solution".

     

    Thanks!

    Dani aka "Mr.Dojo"

    Dojo Admin
    **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"
    **You can update your Dojo Community name and avatar by clicking on your avatar then the "My Profile" button.

Categories