I have one problem regarding average function in Expression Defination. when i am defining if(SALARY > 16500,SALARY,0) then it is giving the expected output.but when i am using if(SALARY > Avg(Salary),SALARY,0) then nothing is apearing in the output ....
I am unable to find the solution of this problem so far.....
Can anybody tell me why it is not working ????????