Sign in
 
HomeOnline20132010Other VersionsRelated ProductsLibraryForumsGallery
TechCenter >
> 
> 
SharePoint Totaling a column help!

Answered SharePoint Totaling a column help!

  • Friday, February 24, 2012 5:35 PM
     
     
    Sign In to Vote
    0

    I've created a vacation day log for my company. I have a few different Calculated Columns. I have "Total Days" for each individual item that is added so for example if someone takes off Feb 1-5 it will return a number of 5. I am trying to return a total number of these days, so if a person takes off Feb 1-5, March 3-5, and April 3 for example it will return a number of 9 in a column called "Days Taken Off".

    Is this possible?

    I've tried everything to no avail! :(

     

All Replies

  • Sunday, February 26, 2012 7:37 AM
     
     Answered
    Sign In to Vote
    0

    Hi,

    Yes this is possible in a slightly different way.

    Follow these steps:

    1. Add a column "Leave" or something  to your calender.

    2. Ask the users to check it while they are applying leaves.

    3. Create a standard view that will be shown only when the leave will be Yes.

    4. Now this will show you the the summary of leaves taken at a single place.

    You can add further logic to show total.

    I hope this will help you out.

    Thanks, Rahul Rashu

     
  • Friday, March 02, 2012 6:32 PM
     
     
    Sign In to Vote
    0

    Thanks! That is a pretty good workaround!

    My next step is to try to return the total number so I can use it for a "days remaining" field.