Filetring an aggregate in OBI
Content
Hello All
I have created a formula to aggregate all candidates into one cell in OBI, I would now like to filter that to just Internal candidates.
LEFT(EVALUATE_AGGR('SYS.STRAGG(DISTINCT(%1 || %2))' AS CHARACTER(1000), IFNULL("Candidate Identification"."Name","Candidate Identification"."Name"),'::'),CHAR_LENGTH(EVALUATE_AGGR('SYS.STRAGG(DISTINCT(%1 || %2))' AS CHARACTER(1000), IFNULL("Candidate Identification"."Name","Candidate Identification"."Name"),'::'))-2)
Thanks in advance
0