Skip to content

    • Magic ETL

    Magic ETL

    Beast mode to filter out certain ID field then sum the remaining IDs 'value'

    Member
    in Magic ETL

    Hi - I am trying to remove certain IDs from a column then sum their values but can't get the syntax correct. Here is what I've gotten to but doesn't work. Problem with adding a filter is the removed values need to be in another line on the chart.

    Case When sum('value') - (when ID='Liability' Then sum('value')) End

    or

    Case When 'ID'= does not contain 'Liability' Then sum('value') End

    Tagged:

    Best Answer

    • Coach
      Answer ✓

      Try this:

      SUM(values) - SUM(CASE WHEN Id= 'Liability' THEN values ELSE 0 END)

      **Check out my Domo Tips & Tricks Videos

      **Make sure to <3 any users posts that helped you.
      **Please mark as accepted the ones who solved your issue.

    Answers

    • Coach
      Answer ✓

      Try this:

      SUM(values) - SUM(CASE WHEN Id= 'Liability' THEN values ELSE 0 END)

      **Check out my Domo Tips & Tricks Videos

      **Make sure to <3 any users posts that helped you.
      **Please mark as accepted the ones who solved your issue.

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories