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.
c_sumif_locate
sumif({Total Spend},locate(col1,'NOT') = 0)
Result:
