Formula help: Adding 2 columns that meet certain criteria

jvsering
jvsering Member
in Magic ETL

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.

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    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

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    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

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Categories