SharePoint University

 I can Total (Sum, Average, etc) columns in lists, but not Calculated columns.  Is it possible to calculate the sum of the entries of calculated column and show that in the view?

For instance, we have two columns for contract leads: ‘Contract Value’ and ‘% gross margin’.  I created a calculated column to show “gross profit”, which is the multiplication of the other two columns.  I can’t seem to TOTAL the value for that calculated column and have that show on the top like the sum (or average) of the other columns.  Is there a way to do this?

I'm using Sharepoint as a work order/project managment system. I've looked all over for a timecard system that will link into a list. I've now decided to build my own, but I have the same problem. PMs enter their time in minutes and I calculate to hours. I'd like to total the hours.

I hope someone responds to this, looks like yours has been out there a while.

Thanks,

Steve

Steve,

I haven't been able to resolve the "total in the view" issue, but really haven't looked much deeper into it.  Anyway, I'm going to suggest something, but I'm not sure if it will serve your purpose.  You can create a KPI (Key Performance Indicator) list with KPIs that will show total hours.  You'd have to create a KPI for Total Hours or an individual one for each PM.  I don't know how many PMs you have, but if there aren't that many this may work.  You can define a KPI so that it totals all the values in a column within a view.  The trick is to create the view filtering for what you want (a particular PM, for instance) and then have the KPI look at that view and sum up the hours.  There are certain tricks here, so let me know if you have any questions.

Sami

I don't think that solves it, at least as far as I can tell. The problem is that it doesn't offer a calculated column as an option when adding totals (i.e. SUM). In our case we're trying to do commissions counting. We used the calculation to take the Total Sale - COGS x Comm.% to get the Commission. Now I would like to total the Commissions column, but no dice.

I have the same issue in regards to calculating the sum of a calculated column.  I believe that it may have something to do with Calculated Column data being rendered as "Text" not a "Number".  I have been working in Data View Web Parts (DVWP's) constructed from data in SharePoint lists.  When I create the DVWP, all of the field data is displayed except for the Calculated column data.  Frustrated by this, I went click happy until I came across the option to "Insert Formula" in the blank cells that should have contained the Calculated column data.  The Insert Formula option brought up the XPath Expression Builder.  I dragged the Calculated column field name into the expression and sure enough the data displayed accurately...however, when I checked out the format of the data, it came across as text.   I do not know of a way to take the Sum of text.  I tried to reformat it as a "Number" only to have the data disappear again.  Perhaps this provides some clues that can help us solve this issue?

 NOTE:  Unfortunatey, KPI's are not an option as I am working in a WSS environment.