ChristineK
2 years agoQrew Cadet
Rollup Help
I've added a new Parent table "Cases" table to my already-established Child "Call Records" table as suggested to me earlier this week, and created a bunch of roll-up fields so that our end users can ...
For this question
Is there any way to create such summary but filter out answers = to "Unknown" or "Not reported", unless they are the only answer? I suppose the alternative is simply to have no answer. We've used Unknown/Not Reported on multi-select text fields for the ability to require the field nonetheless, but if on a subsequent call, the data is known, I'd like to disregard "Unknowns".
You should be able to create a filter on a report or on a combine tech summary field and exclude where
the answer equals Unknown
and where the answer equal Not Reported.