Get Started with Redwood for Oracle Cloud HCM Begin Now
OBI Prescreening Questions with Multiple Answers
Summary
Looking for help with a formula to display multiple answer responsesContent
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.
concat(
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,
Tagged:
0