Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Display values in separate columns
Summary
Display values in separate columnsContent
Is there a way to display the Evaluation Evaluator Name field is separate columns if there are more than one? I have tried using the EVALUATE_AGGR in a formula which works perfectly but the user would like the names to appear in separate columns rather than all in one. If I just add the Evaluation Evalutor Name to the report, each Evaluator would cause duplicate rows of data.
LEFT(EVALUATE_AGGR('SYS.STRAGG(DISTINCT(%1||%2))' AS CHARACTER(1000),"Submission Evaluation Questionnaires"."Submission Evaluation Evaluator Name",'::'),CHAR_LENGTH(EVALUATE_AGGR('SYS.STRAGG(DISTINCT(%1||%2))' AS CHARACTER(1000), "Submission Evaluation Questionnaires"."Submission Evaluation Evaluator Name",'::'))-2)
Tagged:
0