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.
Best answer by CJE
View original