In Beast Mode

DanieleSilva
DanieleSilva 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?

Best Answers

  • ColemenWilson
    ColemenWilson 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

  • david_cunningham
    david_cunningham 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

  • ColemenWilson
    ColemenWilson 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

  • david_cunningham
    david_cunningham 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! ✔️**

  • DanieleSilva
    DanieleSilva Member

    Thank you very much, it worked!

Categories