Jayesh,

Depending on the buffering and views you are using the SELECT will not return the current value for the sum. A SCAN loop or the CALCULATE command will work.

>SELECT SUM(tcfield);
>FROM &lcalias;
>INTO ARRAY lasum