how to avoid NaN error in XML?

Question

I am running a XML Report, When I try to sum the field in the report , <?sum(colname)?> , the output displays NaN. This is strange.

Answer 1

we can void in 2 ways this:

1:
<?xdoxslt:sum(colname)?>
we use xdoxslt sum to avoid the issue while sum fields having null.

2.
<?sum(colname[.!=''])?> is enough try this