Filter function in case statement in otbi column
In my otbi analysis, I tried to add this formula in my column
CASE WHEN "Compensation - Workforce Compensation Budgets Real Time"."Workforce Budget"."Published Worksheet Budget Amount" IS NOT NULL
THEN FILTER("Compensation - Workforce Compensation Budgets Real Time"."Workforce Budget"."Overall Budget Amount" USING ("Compensation Person Worksheet Details"."Work Sheet Manager Name" = 'Benoit De Coriolis (CHRO)'))
ELSE 0
END
But I am getting error [nQSError: 27045] Nonexistent column: "Compensation Person Worksheet Details"."Work Sheet Manager Name". Please have your service administrator review this error. (HY000).
I think it is because of the filter function in my then.
Is there any workaround please?
Tagged:
1