Beast Mode Calculated Field

user00530

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?

Artlyfestyle

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

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!

Artlyfestyle

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

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!

[Deleted User]

@user00530,

 

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

 

Thanks!