Is there any way to sum all values in one calculated column without losing decimal data?
We're using an XPath expression and it loses all decimal information. Where @myField is one calculated column
<xsl:value-of select="@myfield" />
And at the end the end of the group structure
<xsl:value-of select="sum($nodeset/@myfield)" />
I assume the problem is because it's a calculated column as if we use a numeric column it works fine.
There's three level of grouping (username, year, month) The formula is inside the last level.