+10
Hi there,
I have a holiday list, and I would like to display the sum of all days currently in progress when requesting new holiday via NINTEX Forms. It should work like this:
holidaylist:
request 1 2 days in progress
request 2 1 day accepted
request 3 1 day in progress
Now when there is request 4, I would like to display (in the new request form) that there are currently 3 days in progress.
Is that possible?
Cheers
mai-kel
try formula like
sum(lookup('HolidayList','Status','in progress','DaysRequested',true))Works on first try. Frenzy!
Thanks a lot!
Cheers
mai-kel
+10
I need to extend the formula
sum(lookup('HolidayList','Status','in progress','DaysRequested',true))
1. Status should be 'in progress' or 'new' not only 'in progress'
2. two more filters: Employee and Type
Employee = current user (here Michael Weiss)
Type = Regular
Any help is appreciated.
Cheers
mai-kel
that's too many requirements on lookup() function, it only supports single filtering condition.
but you're quite lucky filter on status and type is static and only filter by employee is dynamic.
so you could create a calculated field in list which in case status is new or in progress AND type is regular evaluates to DaysRequested, otherwise it evaluates to zero.
then make lookup() function in form to filter by employee name and return that calculated field. sum over that result set should give you output you need.
+10
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.