Applied thanks.

If you replace this text in the modified dashboard.jsl section i posted, we will get '0' instead of 'NaN' for % columns:

<x:expr select="sum(//aggregator[@name='${aggregatorName.value}'][not(text()='-') and not(contains(text(), '%'))][text()])"/>

Thanks Morten. Actually, I prerfer NaN over 0 as it's not a number!

That said, the best would really be "N/A" instead of NaN.

I see your point. What we could do is to use the "old" <x:expr select..>" but store the select with a <x:set var="theTotal" select=..> and use <j:if..> to set theTotal to "N/A" if theTotal is "NaN".

Here's the new N/A code:

<tr>
<td><b>Total</b></td>
<x:forEach var="aggregatorName" select="project[1]/aggregator/@name">
<td>
<b>
<x:set var="theTotal" select="sum(//aggregator[@name='${aggregatorName.value}'][not(text()='-')][text()])"/>
<j:if test="${theTotal == 'NaN'}">
<j:set var="theTotal" value="N/A" />
</j:if>
<x:expr select="round(${theTotal})" />
</b>
</td>
</x:forEach>
</tr>

Sorry. THIS is more correct:

<tr>
<td><b>Total</b></td>
<x:forEach var="aggregatorName" select="project[1]/aggregator/@name">
<td>
<b>
<x:set var="theTotal" select="sum(//aggregator[@name='${aggregatorName.value}'][not(text()='-')][text()])"/>
<j:choose>
<j:when test="${theTotal == 'NaN'}">
<x:expr select="string('N/A')" />
</j:when>
<j:otherwise>
<x:expr select="round(${theTotal})" />
</j:otherwise>
</j:choose>
</b>
</td>
</x:forEach>
</tr>

Applied. Thanks.