I'm trying to find out how many people answered a multi-select question in a survey. For this count I do not need to know what they picked, simply that they picked something (or didn't not pick anything??)
All my efforts return error: 'Field multi__c does not support aggregate operator COUNT'
Maybe I should create a text formula field that pulls the contents of the multi-select and count the nonblank text field?
Any other options?
(I'm setting this up in Declarative Lookup Rollups app, don't know if it is adding an extra limitation, I can't find reference anywhere to this null issue)
FYI I've tried WHERE field !='' WHERE field != NULL WHERE Field EXCLUDES (NULL)