Thank you so much for your response. I am extremely sorry I made a mistake in explaining the problem. I apologize for that. Here is the correct explanation. a) When Permanent = 1 and Year_ID = -3 then Average_Salary = Salary; When Permanent = 1 and Year_ID = -2 then Average_Salary = [Salary(Year_ID= -3)+Salary(Year_ID= -2)]/2; When Permanent = 1 and Year_ID = -1 then Average_Salary = Salary; When Permanent = 1 and Year_ID = -0 then Average_Salary = Salary; When Permanent = 1 and Year_ID = 1 then Average_Salary = Salary; When Permanent = 1 and Year_ID = 2 then Average_Salary = Salary; When Permanent = 1 and Year_ID = 3 then Average_Salary = Salary; b) When Permanent = 0 and Year_ID = -3 then Average_Salary = Salary; When Permanent = 0 and Year_ID = -2 then Average_Salary = Salary; When Permanent = 0 and Year_ID = -1 then Average_Salary = Salary; When Permanent = 0 and Year_ID = -0 then Average_Salary = Salary; When Permanent = 0 and Year_ID = 1 then Average_Salary = [Salary(Year_ID= 0)+Salary(Year_ID= 1)]/2; When Permanent = 0 and Year_ID = 2 then Average_Salary = Salary; When Permanent = 0 and Year_ID = 3 then Average_Salary = Salary; Thank you.
... View more