none
SharePoint Totaling a column help!

    Question

  • 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! :(

    Friday, February 24, 2012 5:35 PM

Answers

  • 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

    Sunday, February 26, 2012 7:37 AM

All replies

  • 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

    Sunday, February 26, 2012 7:37 AM
  • 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.

    Friday, March 02, 2012 6:32 PM