Bi Publisher / XML Publisher: RTf Template Unable to Sum with NULL data

Sum results in NaN

RTF Template: If your column contains Null value the XML publishers SUM function results in NaN.

<?sum(current-group()/ELEMENT_NAME[.!=''])?> 

<?xdoxslt:sum(Amount))?>

Get XML Publisher report Output file

Get the Request Output File for a XML/BI Publisher based concurrent report:
The output is $APPLCSF/$APPLOUT/{REPORTNAME}_{REQUEST_ID}_{COUNT}.PDF|RTF|EXCEL|HTML



REPORTNAME is the concurrent program short name,
REQUEST_ID is the concurrent request ID
COUNT is a counter based on the number of times a request has been re-published.
One of PDF, RTF, EXCEL, HTML is the file extension/type dependent on the output formats chosen.