Hello All,

I have been tackling this issue for so long. I have a report that gives me the average team performance per function. Another report that gives me Individual performance per Function.

What I want to do is show the individual's performance against the team performance side-by-side.

I came up with this formula in the Team Performance but it's not giving me the correct number:
=(Nz(DLookUp("[TeamAve]","qryProductivity_Test","[FunctionsID]=[txtfunctionsID]")))

so what i want with the above code is to show the TeamAve for the FunctionsID that equals txtFunctionsID from the quryProductivity_Test.

I am getting some numbers but it's not the sum of all TeamAve for the FunctionsID.

Thank you for your help.

I have made some changes to the above post. Thank you