script error

[qvqfqlik]

I am getting Invalid expression script error . I might be overlooking, but couldn't find whats wrong with this.

please help.

[qvqfqlik]

this is correct too. Thank you

[sunny_talwar]

Is everything resolved now?

[jayanttibhe]

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

  ;

[qvqfqlik]

yes, thankyou

[vikramv]

Glad you found it!!