Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Sharepoint Colum sum

  Asked By: Joseph    Date: Feb 07    Category: Sharepoint    Views: 1257

I have a problem. Can't seem to find a solution. I use Infopath
(2003) and Sharepoint.

Our office of 20 work overtime, but we are not paid hour-for-hour for
the overtime. Our overtime is averaged over the previous 52 week period.
We need a way (ideally in Sharepoint) to add each person's overtime
hours for each week in each pay period (week 1 week 2). Easy enough.
But then we need to keep a running total for all 26 pay periods in a
year. Then average that running total by the 52 weeks.

I may not have explained that well. We need to keep track of the
hours worked on one week. The two weeks are added and put into a
column. Every pay period that number (the total of the hours worked
in each pay period) must be added to the running total for the
previous 52 weeks. Then a running average, if you will, must be kept
going as well. The oldest pay period (the first one, or the oldest
one at the beginning of the 52 week cycle) must be shaved off the top.

It seems like I am making more out of this than it is, but I just
can't figure out a way to do it. I was thinking of a marriage between
Infopath, to do some of the calculations, and sharepoint to display
the data and allow for some filtering, different views, etc....



No Answers Found. Be the First, To Post Answer.

Didn't find what you were looking for? Find more on Sharepoint Colum sum Or get search suggestion and latest updates.