Solved

Query List: How to store column value only in a collection variable?

  • 30 April 2020
  • 1 reply
  • 24 views

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: [{"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.

icon

Best answer by CJE 30 April 2020, 15:23

View original

1 reply

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