Hi Sunny,
I know this has been resolved but in this case preceding load is not required.
Like this :
;
LOAD
%MATERIAL_KEY,
%LOCATION_KEY,
%ACCT_CAL_FACT_KEY
, Sum(Avg_WKLY_DMD_Current) as Avg_WKLY_DMD_Current
, Sum(Avg_WKLY_DMD_2Weeks) as Avg_WKLY_DMD_2Weeks
,(Sum(Avg_WKLY_DMD_Current) + Sum(Avg_WKLY_DMD_2Weeks)) / 3 as Avg_WKLY_DMD
, %MATERIAL_KEY&'-'&%LOCATION_KEY as Mat_Loc_Key
Resident
PSI_Data
Group by
%MATERIAL_KEY,
%LOCATION_KEY,
%ACCT_CAL_FACT_KEY
;
