Skip to content

    • Magic ETL

    Magic ETL

    Beast Mode Calculated Field

    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?

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Best Answers

    • 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

    • 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

    • 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

    • 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'
    • Member

      @user00530,

       

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

       

      Thanks!

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories