rpage18_
Nintex Newbie

Lookup runtime function in Calculated Value field for multiple selections on form.

All,

 

I'm needing to display multiple numbers according to certain values selected from a list lookup on a form. As an examples, I am using a list called "Testing List". In the List Lookup field on the form, multiple selections are allowed from the column called "Title" from the "Testing List" list. Each selection has an according number that goes with it. These numbers belong under the "Score" column from the "Test List" list. 

The source list:

rpage18__0-1590612619673.png

The List Lookup:

rpage18__2-1590612941857.png

The Calculated Value:

rpage18__3-1590613025820.png

The form:

rpage18__1-1590612753823.png

What I was expecting to happen was for all Score(s) to populate, but only the first one selected does (in this case, 3). If it is too small to read in the screenshots, here is the formula used for the calculated value: lookup("Testing List", "Title", parseLookup(TestingListValues, true), "Score"). I read somewhere that including "true", without quotes, would pull multiple values. 

I was eventually planning on adding avg() and min(), separately, to the beginning of the formula to find both the average and the minimum Score. 

 

Thank you in advance for any help!!

 

0 Kudos
Reply
2 Replies
SimonMuntz
Nintex Employee
Nintex Employee

Re: Lookup runtime function in Calculated Value field for multiple selections on form.

Hi,

I do not think this will work. You can retreive multiple values when doing a lookup but when doing a lookup you cannot pass multiple values to the lookup runtime function and that is why only the first selection is being looked up.
0 Kudos
Reply
rpage18_
Nintex Newbie

Re: Lookup runtime function in Calculated Value field for multiple selections on form.

I was afraid of that.... Do you know an alternative solution that would work? Thanks!
0 Kudos
Reply