I have a calculated column in a list and I would like to get a sum of that column in the view. I can't use datasheet view, and I don't like the idea of a workflow because the user only sees a few records that are being summed. Any suggestions?
If you are using a SharePoint data view you can display the count of a column using XSL
< xsl:value-of select="sum(/dsQueryResponse/Rows/Row/@ColumnName)" />
I hate bubbling old topics up, but I ran across this thread today and noticed it had lots of views and no answers.
A really simple way to do this is to create a workflow that runs automatically on new/edit list items and all it does is copy the calculated value to a "normal" number column and then sum that column in the view.
I don t there is a direct way to do this. Please check the link below.I hope this would help. http://community.bamboosolutions.com/blogs/bambooteamblog/archive/2009/04/24/how-to-total-calculated-columns-in-a-sharepoint-list.aspx
Can you check this post and get some idea?
If you use a DateView Web Part this blog post could help you out: