Answers for "How to do average for differents persons" The latest answers for the question "How to do average for differents persons" Answer by gcusello Hi Abarny, sorry but I don't understand your need: do you want a table like the one in your screenshot? or do you need to format your number? If you insert a stats command at the end of your search you have only this value, if you need to add avg(MoyenNoDec) to your search you have to insert it in the previous stats command or insert with the values option in the last stats command the other values you have, in other words, something like this: stats values(nbpres) AS nbpres values(AppleID) AS AppleID values(ACResponse) AS ACResponse avg(MoyenNoDec) why in the last stats command there isn't the BY clause? In addition, in your search you don't need to insert the table commands between stats commands, in this way your search is slower! Bye. Giuseppe. Mon, 06 Mar 2017 10:12:44 GMT gcusello