Data View Web Part Calculated Column Total (Sum)Dedek,
I added 'format-number' function:
<xsl:value-of select="format-number(sum($nodeset/@ows_Pallets_x0020_On_x0020_Hand), '#,#0;-#,#0')"/>
This returned a blank.
Since the orginal values were displayed as (e.g.) "float;#17115.00000", I had changed the <td> code to:
<xsl:value-of select="format-number(substring-after(@ows_Pallets_x0020_On_x0020_Hand,';#'),'#,##0;-#,##0')" />
Therefore, I also tried the following code for the total:
<xsl:value-of select="format-number(substring-after(sum($nodeset/@ows_Pallets_x0020_On_x0020_Hand),';#'), '#,#0;-#,#0')"/>
Also retruned a blank.

DVWP Wrong Group CountThanks for the feedback. I found the solution. It turns out I cannot group based on mm/dd/yyyy date format. In order for me to group and get correct column totals the date must be in yyyyMMdd format. So I added a calcuated date column with yyyyMMdd format and it worked.
Thank you vey much for your help.

Mar
13

comment

DVWP Wrong Group CountI noticed in your post you defined 'nodeset'. I have pasted my code with code parameters, I would appreciate if you can tell me how I can define the 'nodeset' to include all rows in a group. Or if there is a way I can use dsQueryResponse to generate the group count. Thanks.

Mar
13

comment

DVWP Wrong Group CountYou are right my questions is very similar to your issue. I had reviewed your post first before posting my question.
There are many reasons, but one main reason why I know that it is not the date format or column that is causing the issue is because I am calculating a total sum for one the numeric columns as well. The sum has the same issue. The total is correct for the last group but zero for all others (I also tried deleting the last group to see what happens. In this case the initial second to last group became the last group and had correct calculation and all other group were zero).