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