Skip to content

    • Beast Mode

    Beast Mode

    In Beast Mode

    Member
    in Beast Mode

    I need a formula where I can add the "Spot" and "Fixed" columns but only filtering values ​​that are like "GET". How could I do?

    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

    Best Answers

    • Coach
      edited June 2024 Answer ✓

      If you are looking for anything "like" GET then you can use the following beastmode and then apply it as a filter:

      CASE WHEN UPPER(`yourField`) LIKE '%GET%' THEN 'In' ELSE 'Out' END

      If you want only rows where the field is equal to GET then you would use:

      CASE WHEN UPPER(`yourField`) = 'GET' THEN 'In' ELSE 'Out' END

      If I solved your problem, please select "yes" above

    • Coach
      Answer ✓

      If I'm understanding you correctly, you want to add 2 numeric columns (Spot & Fixed) when another unnamed column is equal to the value "GET". If that is true.

      CASE WHEN Unnamed Column = "GET" then Spot + Fixed END

      If you want to aggregate up, you can either do that in your card settings, or in the beast mode itself.

      SUM(CASE WHEN Unnamed Column = "GET" then Spot + Fixed END)

      David Cunningham

      ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
      ** Did this solve your problem? Accept it as a solution! ✔️**

    Answers

    • Coach
      edited June 2024 Answer ✓

      If you are looking for anything "like" GET then you can use the following beastmode and then apply it as a filter:

      CASE WHEN UPPER(`yourField`) LIKE '%GET%' THEN 'In' ELSE 'Out' END

      If you want only rows where the field is equal to GET then you would use:

      CASE WHEN UPPER(`yourField`) = 'GET' THEN 'In' ELSE 'Out' END

      If I solved your problem, please select "yes" above

    • Coach
      Answer ✓

      If I'm understanding you correctly, you want to add 2 numeric columns (Spot & Fixed) when another unnamed column is equal to the value "GET". If that is true.

      CASE WHEN Unnamed Column = "GET" then Spot + Fixed END

      If you want to aggregate up, you can either do that in your card settings, or in the beast mode itself.

      SUM(CASE WHEN Unnamed Column = "GET" then Spot + Fixed END)

      David Cunningham

      ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
      ** Did this solve your problem? Accept it as a solution! ✔️**

    • Member

      Thank you very much, it worked!

    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