Formula help: Adding 2 columns that meet certain criteria

jvsering

I am trying to sum up 2 columns that meet certain criteria and would like to create a new column with the values.

Here's what I have so far:

SUM(
CASE WHEN Goal Funnel Category = 'Interest' THEN Total Actions
WHEN Page Funnel Category = 'Interest' THEN Total Actions
ELSE 0
END
)

I am getting the error below but wasn't sure how to apply.

Calculation Error : Function SUM requires an aggregation context. Use the Group By action.

GrantSmith

Are you doing this inside a formula tile or a beast mode? If it’s a formula tile in ETL you can’t use aggregations (SUM) as it doesn’t know how to group them. You can do it using a group by tile in magic instead and have a custom aggregation

alternatively you can remove the sum in your formula and then just sum your new field in your card

GrantSmith

Are you doing this inside a formula tile or a beast mode? If it’s a formula tile in ETL you can’t use aggregations (SUM) as it doesn’t know how to group them. You can do it using a group by tile in magic instead and have a custom aggregation

alternatively you can remove the sum in your formula and then just sum your new field in your card