OBI Prescreening Questions with Multiple Answers
SummaryLooking for help with a formula to display multiple answer responses
Hi, I'm looking for help on an OBI formula in order to report in one "cell" all the responses to a multiple answer prescreening question.
In BO, the way to do this was using a rank and then combining the answers into one variable. I think the same concept would probably work but can't quite seem to figure it out.
case when rank(case when "Candidate Q&A"."Question Code"='NH13_026' then "Candidate Q&A"."Answer (Choice) (BL)" end by "Submission General Info"."Submission Identifier","Candidate Q&A"."Answer (Choice) (BL)")=1 then "Candidate Q&A"."Answer (Choice) (BL)" end,