Beast Mode Calculated Field

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
    Accepted 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
    Accepted 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!

Answers