Oracle apps r12 XML Template sum of column showing output as NNNN

if AMT is your column to be sum in the rtf template then use as below.

<?sum(AMT[.!=''])?>