Forum Discussion
richrich123
6 years agoHelper III
Filtering out 'non responses'
Hi all, Im struggling to find a way to see a list of customers who havent submitted any survey responses. Im sure there must be a way but Im struggling to find one that works. I send out a su...
- 6 years ago
Yes. [Score] is correct (my bad). Also, since that must be a numeric column, the "" isn't working. You can replace that part with >0 (or >-1, if you expect 0 Scores in the data) in place of the <>"".
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
mahoneypat
6 years agoMicrosoft Employee
Yes. [Score] is correct (my bad). Also, since that must be a numeric column, the "" isn't working. You can replace that part with >0 (or >-1, if you expect 0 Scores in the data) in place of the <>"".
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
richrich123
6 years agoHelper III
mahoneypat, fantastic, all working - much appreciated!