Hi Waleed,
I have found a way to sum exclude the undeleted record. I use :-

SUM colname FOR NOT DELETED() TO varname

and it works well.

Regards.