topic Re: multiple column mean in Discussions

multiple column mean

susanho1225 — Tue, 08 Jul 2025 22:09:21 GMT

See attached, I tried to add a new column for mean from 3 other columns by "col mean( col1, col2, col3)". But the mean seems a little bit off, and I used "(col1+col2+col3)/3" to verify, and it gives me the correct result. What is the possible cause of this?

Re: multiple column mean

txnelson — Wed, 09 Jul 2025 02:44:06 GMT

You don't want the Col Mean() function, you just want the Mean() function

Re: multiple column mean

Mark_Bailey — Wed, 09 Jul 2025 14:51:33 GMT

Expanding on @txnelson's suggestion, the Col Mean() function uses the additional arguments after the first to group the data. This behavior is very convenient, but, as he said, not what you want this time.