Report Control not getting the value

[ThePhantom]

Hi,

I have an aggregated report based on a GROUP BY query, which groups a numeric column called 'Lag' by Department, and then Division & Location.....

However, I need an average value of this lag per department. Since, this value cannot be accomodated in the query, I created a text control and made its Data Source to -->

=(SELECT Round(Avg(doe-dos)) FROM lag Where lag.lvl4 = Reports!rptLag!lvl4)

However, I get a display error. Here, Lvl4 is the department by which I am grouping the data.....

Can anyone suggest the correct way??

Thanx,
Aashish.