Help needed in display of Data

HCL Domino Domino Forum
1

I have a database that is used for Attendance. Each user has a profile Document with their name, title, and how many vacation hours, personal hours, and carry over hours for the year that they have. There is a 2nd form, the Request Time off form. The associate can fill out the form to request time off, such as a 1/2 day or full day. It is then sent to the supervisor for approval or not. If Approved then it is shown in a private for the associate, the day off and how many hours. So 1 day off = 8 hours. IT is also listed in a Team view for the supervisor. My basic isssue is this. I would like to display some how the following, either in a view or a page or someplace:

Associate Name: John Doe

Total Vacation: 120 hours

Total Used: 8

Total Vacation Left: (120-8) - 116 hours.

I am stuck on this. I have a view right now that show them the type of time off. So it is catagorized by Type, such as Vacation, Overtime, Personal but how or what would be the best way to combine the information into one location for the associate to see what they have, what is left, and what they have used.

Any help would be most appreciated - or just an opinion on a direction to go in would be great. Thank you

Ann

2

Subject: Help needed in display of Data

Not clear of the problem, can you not add extra columns that shows total days off taken or tot days left.

Alternatively may be you can total the days off and that will show as total of days off on the top category.

3

Subject: RE: Help needed in display of Data

If I create the view from the Time Off Request form, I can total the total approved hours taken for each of the 3 categories, Vacation, Personal, and Overtime, I am just not sure how to take that total and subtract from the intial quanity of time each associate if given. Example:

John has taken 2 vacation days, and it would show in the view under a category of Vacation, then the days he has off and the next column is his total vacation hours used - 16, and from his profile document, he has a total of 120 vacation hours to use during the year. I wanted to know if it is then possible in someway to have another column say 120-16 and show that he has 104 hours for vacation time remaining.

Does that help?