Forum Discussion
Quotation mark in Text Filter
I am having trouble to filter data in new column:
I have new column which i want to be filled like
Column 2 = if( [Retailer] = """KDK""", "YES", "NO")
The data i am looking for in column Retailer is "KDK"
Above syntax doesnt work for me for some reason, please give better solution
Thanks in advance.
Another method
Column2 = VAR _text =UNICHAR(34)&"KDK"&UNICHAR(34) VAR _result = IF([Retailer]=_text,"Yes","No") return _result
2 Replies
Hi User777
It should work with your expression as shown in below screenshot,Could you please provide any screenshot of your incorrect output or error message ?
Thanks!
Inogic Professional Services Division
Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!
Drop an email at [email protected]
Services: http://www.inogic.com/services/
Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/
Another method
Column2 = VAR _text =UNICHAR(34)&"KDK"&UNICHAR(34) VAR _result = IF([Retailer]=_text,"Yes","No") return _result
