I am receiving an 'Index 0 out of bounds for length 0' when using a double lookup. I am guessing there is some data missing in the lookup keys, but I am not sure how to account for that (?).
LOOKUPVALUE(0,LOOKUPVALUE(0,[WFM-EmployeeBalanceLog.GHR Employee ID],1,SELECT [Work Assignment.Employee Key],[Work Assignment.HR Organization Unit Key] FROM [ALL]),1,SELECT [HR Organization Unit Chart.HR Organization Unit Key],[HR Organization Unit Chart.HR Organization Unit Key] FROM [ALL]) WHERE [WFM-EmployeeBalanceLog.GHR Employee ID] IS NOT NULL
Please and thank you,
Lisa