Beast Mode Calculated Field

user00530 Member

June 2018 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?

Domo query.xlsx 9.3K

1

Best Answers

• 

  Artlyfestyle Domo Employee

  June 2018 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

  3
• 

  PodiumMason Contributor

  June 2018 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'

  3

Answers

• 

  Artlyfestyle Domo Employee

  June 2018 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

  3
• 

  PodiumMason Contributor

  June 2018 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'

  3
• 

  [Deleted User] Member

  June 2018

  @user00530,

   

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

   

  Thanks!

  0