AnsweredAssumed Answered

Lookup inline function not working as intended in Nintex Form

Question asked by razvanhr on Mar 16, 2017
Latest reply on Mar 17, 2017 by razvanhr

Hi all. I have a list and a Nintex List Item Form (2013). In the list there is a column named "Days Requested" (DisplayName) which contains comma-valued numbers 1.5, 2.0 etc.

 

I want to use the lookup function to sum the already submitted items so I have a formula control and do

 

Sum(lookup("MyList","Author",Current User,"Days Requested",true))

 

This always gives me 0

I have tried the same with the intDaysRequested (Internal Name) instead of the Display Name, still 0

I am using the International version with a german browser.

I will mention that if I use a Lookup Control on the form with the same data and field internal name I get the values I need (but of course not the sum)

 

Any ideas why it doesn't work in the formula?

 

Thanks and Cheers

Outcomes