Filtering with custom filter tool

Question

Hi. My data is V_String, and some metrics in column [Account"] have already quotation marks on it as part of the metric name (i.e. "3653 O....."). If I were to filter using  [Account] IN ("3435 O...", "3457 O..", ""3653 O....."") and place quotation marks before the metric name, I end up using double quotation marks for those metrics, and get an error. If I only use them once, the metrics get excluded. How can I go around that?

Mari1 · Answer

Thank You!

Maskell_Rascal · Answer

Hi @Mari1

Use single quotes vs double quotes when writing your formula and it should solve your problem.

[Account] IN ('3435 O...', '3457 O..', '"3653 O....."')

Cheers!

Phil