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:
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?
Solved! Go to Solution.
I need to extend the formula
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.
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.