Jun 30
Sharepoint 2007 calculated column total?
soofoo asked:
I have a list in sharepoint 07 which also contains a calculated column based on cost per usage. column x * column y = total. I have also identified a cost code to each record. I’d like to do a running sum of the totals by cost code. If it were a spreadsheet, I could just sum on the total column. But this is a list, which is grouped by cost code. Is there a way to do a final sum of the total column by cost code?
I have a list in sharepoint 07 which also contains a calculated column based on cost per usage. column x * column y = total. I have also identified a cost code to each record. I’d like to do a running sum of the totals by cost code. If it were a spreadsheet, I could just sum on the total column. But this is a list, which is grouped by cost code. Is there a way to do a final sum of the total column by cost code?
What I want to do is calculate the grand totals by division.
Tags
Basketball bears nfl schedule bet on football betting bino harness blackjack boating camping casino casino and gambling casinos chicago bears season entertainment Exercise family counselor family therapist fishing fitness football Gambling Game Games gaming golf health hobbies internet Las Vegas leisure Martial Arts Nfl NFL Betting Olympics outdoors poker recreation recreation and sports roulette soccer coaching soccer drills Soccer practice Sport Sports surfing vacation
One Response to “Sharepoint 2007 calculated column total?”
You will need to create a custom view and then edit the view in Sharepoint Designer. You will right-click the view and convert to XSLT, and have XSLT do the calculations for you. You will need to know XSLT to accomplish this.