Contains filter Calculated Field

How can I make a does not contain filter using a calculated field? I tried something like below but it did not work.

Hi @Carolina_Pereira -

You can use this approach.

1. Create a calculated field that uses the locate function. This is case sensitive and the function returns 0 if it doesn’t find the string.


sumif({Total Spend},locate(col1,'NOT') = 0)