LOOKUPVALUE results in more than one row

Lisa Callahan

I am using a lower grain to lookup a higher grain which results in more than one row in Visualizer.

The code is below. There is more than one work unit key per Member Organization (HR Organization Unit Level 2), which is why I am getting duplicate rows.

LOOKUPVALUE(0,[Work Unit.Work Unit Key],1,SELECT [HR Organization Unit.Work Unit],[HR Organization Unit Chart.HR Organization Unit Level 2] FROM [ALL])

My current solution is to put everything in a Designer report and add a group for Member Organization, but I am hoping there is something I am missing that can be done in the code(?)

Diane McElhiney

Work Unit Key in the screenshot seems unique, therefore it should return one value for Member Organization. Try LOOKUPROW as that provides more control over which row to return (majority of the time 0).