Calculating a sum from a list of data and add it to a specific user

Need help
1

Hi all,

I am building a vacation planner and want to calculate remaining vacation days for my users (employees).

What I have:
I have two different data types: user (employee) and absences.
The user employee has a data field called Absence_Vacation Days planned. In this field I always want to displayed the amount of vacation days the user (employee) has still to plan for the remainder of the year.
The data type absences has a field with the number of days planed for each absence period.

On top I have an approval process. An employee is requesting vacation, this request is routed to the manager for approval. Via an repeating group the manager is getting displayed all open requests.

What I need:

  • the number Absence_Vacation Days Planned in the data base of the user should always be the sum of number of days from each absence period from this particular user (employee) which is either open or approved but not contain the number from the rejected absence periods.

Can someone support?

2

You can put a field on the user that is related to abscence and make it a list and from that can craft an expression current users abscence days sum

3

This topic was automatically closed after 70 days. New replies are no longer allowed.