Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I'm developing a leave system using Sharepoint 2010 and I have stored following data on a sharepoint list.

**Applied Days 3 , 5 ....................

Sum of Applied Days 3 , 8 (Can't get this values)

Remaining Days x , x**

For calculate Remaining Leave days I need to count sum of applied days. but i can't get the cumulative value of applied days. there is no formula calculate All Applied Days(or Current Applied Days + previous Sum of Applied Days). so simply what I need to do is get the sum of a column value.

Is there any method to do this in sharepoint 2010??

share|improve this question
1  
More detail of your solution is needed to be able to help. Are you storing each leave request as a new item in the list? Does each person have their own list or are all the leave requests mixed up together? If everything is in a single item for each user then the calculated column suggested below is good. If not then you will probably need to work with XSL and XPath to get the totals you need. –  Dave Paylor May 15 '13 at 9:23
add comment

1 Answer

Create Column. I assume the name of the column SumOfDaysColumn.

The properties will be like this:

Column type :calculated

returned type: Number

In Additional Column Settings>Formula: [SumOfDaysColumn] = [AppliedDaysColumn] + [PreviousDaysColumn]

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.