cancel
Showing results for 
Search instead for 
Did you mean: 
mai-kel
Nintex Newbie

Lookup several values out of a list and display the sum of them in a NINTEX Form

Jump to solution

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

Labels: (1)
0 Kudos
Reply
5 Replies
Automation Master
Automation Master

Re: Lookup several values out of a list and display the sum of them in a NINTEX Form

Jump to solution

try formula like

sum(lookup('HolidayList','Status','in progress','DaysRequested',true))

View solution in original post

Reply
mai-kel
Nintex Newbie

Re: Lookup several values out of a list and display the sum of them in a NINTEX Form

Jump to solution

Works on first try. Frenzy!

Thanks a lot!

Cheers

mai-kel

Reply
mai-kel
Nintex Newbie

Re: Lookup several values out of a list and display the sum of them in a NINTEX Form

Jump to solution

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

0 Kudos
Reply
Automation Master
Automation Master

Re: Lookup several values out of a list and display the sum of them in a NINTEX Form

Jump to solution

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.

Reply
mai-kel
Nintex Newbie

Re: Lookup several values out of a list and display the sum of them in a NINTEX Form

Jump to solution

Wonderful! That also worked quite fine.

Thanks a lot

Reply