Solved

Vertically Calculate Count, Total in sharepoint and store in variable for future use

Posted on 2009-04-07
4
795 Views
Last Modified: 2012-08-13
How to Calculate total vertically in sharepoint.
i.e share offer a total with colunm A + Colunm B
but my requirement is to calculate Total in respect of Rows
i.e SUM ( Row-1-ColunmA + Row -2-Colunm A) for get the Desired Result. i need this colunm for Calculation please any body help

   
0
Comment
Question by:wateenitdev
  • 2
4 Comments
 
LVL 11

Accepted Solution

by:
thman earned 250 total points
ID: 24087458
You need to create a page and insert a DataFormWebPart. In that web part, you can use XSLT to do the calculation. To find an example, you can use SharePoint's HelpDesk template to create a site and use SharePOint Designer to open the default.aspx page which has codes for the KPI indicator on the page. It shows you how to get the sum for each issue status and then calculate a percentage for each issue status.
Or you can use SQl Server Reporting Service to generate reports. This approach is bit long path to go if you are not familiar how SharePoint stores data.
 
0
 
LVL 15

Assisted Solution

by:dp_expert
dp_expert earned 250 total points
ID: 24094992
Or you could create a workflow with SharePoint designer (now it is a free tool) that would calculate after each item change and store the calculation result in some other list and then insert the calculation result in a selected columns of selected item
0
 
LVL 11

Expert Comment

by:thman
ID: 24096336
It is not easy to do that in SharePoint Designer workflow - the functionalities are very limited. It is possible to do it in event handler which is programmed in Visual Studio.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Last week I faced a strange issue recently, i have deployed SharePoint 2003 servers for one project and one of the requirements was to open SharePoint site from same server. when i was trying to open site from the same server i was getting authentic…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now