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?
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
Thank You!