In Beast Mode

DanieleSilva

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?

ColemenWilson

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

david_cunningham

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)

ColemenWilson

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

david_cunningham

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)

DanieleSilva

Thank you very much, it worked!