Sum() in load script

[govindvasu]

Hi,

I am trying to implement sum functionality in the data load editor, when loading the data it is throwing the invalid expression error. 

Here is the script i am running

Data_total:

load

     emp_id,

     key,

    amount,

     sum(amount) as Sum_amount

resident Data

where Key = 0

and Date >= addmonths(today(), -12)

group by emp_id;

[govindvasu]

Thanks this works