Highlighted
White Belt

## Summing with Beast Mode

Is there a way to sum an entire column in beast mode, creating a new column with the sumif of another column?

Accepted Solutions
Highlighted
Major Blue Belt

## Re: Summing with Beast Mode

According to Tyler R., this is the solution:

“Yes, you can sum an entire column in Beast Mode, creating a new column with the SUMIF of another column. However, the specific use case you provided would first require some pre-aggregation of the data prior to the building of the card. This would require the use of DataFlows. If you need assistance with doing this in DataFlows, please let us know.”

All Replies
Highlighted
Green Belt

## Re: Summing with Beast Mode

Welcome to Dojo, selbadramany.  Since the sumifs of a column are usually what shows up in graphs and charts in Domo, I am a bit curious as to why you wish to sum them in beast mode.  Could you share what you are trying to accomplish?

"When I have money, I buy books. When I have no money, I buy food." - Erasmus of Rotterdam
Highlighted
Green Belt

## Re: Summing with Beast Mode

Edit: Removed initial comment as I didn't read all of what Nalbright stated.

Highlighted
Green Belt

## Re: Summing with Beast Mode

It happens

"When I have money, I buy books. When I have no money, I buy food." - Erasmus of Rotterdam
Highlighted
Moderator

Highlighted
White Belt

## Re: Summing with Beast Mode

I am trying to sumif a column in order to perform a beast mode calculation that would have a single data point from one column divided by the sum of all data points in another column. Thx

Highlighted
Moderator

## Re: Summing with Beast Mode

Hi all,

Is anybody able to assist @selbadramany with their question?

Highlighted
Major Brown Belt

## Re: Summing with Beast Mode

There is no sumif function within beast mode. However, you can use a CASE statement within the sum function to get to same results.

i.e. SUM(Case when `<fieldname>` = 'test' then 1 else 0 end )

or

SUM(Case when `<fieldname>` = 'test' then `<ValueField>`  else 0 end )

Domo Arigato!

**Say 'Thanks' by clicking the thumbs up in the post that helped you.
Highlighted
Green Belt

## Re: Summing with Beast Mode

You can use AND in your CASE statement to effectively function like a SUMIF in excel. Something like this -- might take a bit of tweaking for your needs...I chose to divide "/" but you could just as easily use any other operator there.

(

SUM (CASE WHEN `field` LIKE '%THIS%' AND '%THAT%' THEN `fieldvalue`)

SUM (CASE WHEN `field2` LIKE '%this%' AND '%that%' THEN `fieldvalue2`)

)

Highlighted
White Belt

## Re: Summing with Beast Mode

Thanks.  I understand the case and AND/OR functionality.  What I am trying to accompplish is this:

I have columns with date, unique customer identifiers and unique customer transaction identifier (so a customer may 1-2 transactions per year).  I want to calculatate for customers who had a transaction in 2011, how many transactions did they have in 2012, 2013, and 2014.  My challenge has been identifying the unique customers in 2011 AND THEN counting all transactions in 2012, then 2013, then 2014 for those specific customers.

Announcements
Coming Soon: Weekly Virtual User Meet-ups to answer all your questions! Stay tuned for more details to come this week.