Skip to main content

Hi everyone,

I have a list with number values in a column ("Score") and I want to get the average of all those values. The smartest way I found to do this (is there a smarter way?), is to run a query for that column, then add up all values and divide it by the total count.

 

The output via history log looks like this:

 

Score Count: 2 ScoreCol: l{"Score":0.5},{"Score":0.714285714285714}]

 

Indeed, I have 2 items in that list. But why the heck does the query store the name of the column in the collection as well? I can´t figure out, how to change this behavior. And all my attempts to work around this and delete the name part from the collection have failed so far. Please help.

Once I have submitted the question, I found the solution...



 



https://community.nintex.com/t5/Nintex-for-Office-365/Need-help-with-Collection-variable/m-p/75512



 



I am pretty sure, I tried that before... But anyway, problem solved.


Reply