Filtering with custom filter tool

[Mari1]

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?

[Maskell_Rascal]

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

[Mari1]

Thank You!