Beast Mode Calculated Field

user00530
user00530 Member
in Magic ETL

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 Domo Employee
    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 Contributor
    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

  • Artlyfestyle
    Artlyfestyle Domo Employee
    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 Contributor
    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'
  • [Deleted User]
    [Deleted User] Member

    @user00530,

     

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

     

    Thanks!

Categories