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