Solved

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

Posted on 2009-04-07
4
806 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

813 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

18 Experts available now in Live!

Get 1:1 Help Now