Ventana software support forum • Calculate average for an array

Page 1 of 1

Calculate average for an array

Posted: Tue Jul 21, 2015 9:15 am

by carlaIT

Hello,

How can I calculate the average for an array. I see that is posible to SUM and PROD but can´t find the AVG, is there any workaround?

Thanks!

Re: Calculate average for an array

Posted: Tue Jul 21, 2015 4:15 pm

by Rafael

See the attached model

Rafael

Re: Calculate average for an array

Posted: Tue Jul 21, 2015 4:53 pm

by Administrator

It's really easy,

sum ( some value[array!] ) / elmcount(array)