Averaging formula Forum Home › Forums › Understanding the Software › Using Formulas › Averaging formula This topic contains 5 replies, has 2 voices, and was last updated by Mikhail 10 months ago. Viewing 6 posts - 1 through 6 (of 6 total) Author Posts January 21, 2019 at 10:31 pm #4926 HoracioParticipant Hello! Could you please show the formula you used for channel 115 (Average temperature) of your “Server Room” demo? Could you show another example of an input channel averaging formula, after ticking the “averaging” case? Please include Input channel type. January 22, 2019 at 2:37 pm #4930 MikhailModerator Hi, Something like (Val(1) + Val(2) + Val(3)) / 3 where 1, 2 and 3 are input channel numbers. You need to add an extra input channel of calculated real type that uses the above formula. January 22, 2019 at 4:42 pm #4931 HoracioParticipant Thank you very much Mikhail. That’s fine to average different variables. How to do to average same variable along a certain time (n previous readings)? What does “averaging” column in Input Channels work if marked? I saw other postings referring this subject but the matter remains unclear to me. Thank you. January 23, 2019 at 1:40 pm #4935 MikhailModerator How to do to average same variable along a certain time (n previous readings)? Create new formulas in the Formulas table depending on your needs. There are many different ways to calculate averages. What does “averaging” column in Input Channels work if marked? Summarizes all values received from controller and then divide by their count. This is performed separately when write minute and hourly data in the archive. January 23, 2019 at 2:07 pm #4937 MikhailModerator I implemented several averaging formulas in different projects. I can help you with averaging based on your requirements. But this is out of free support. February 4, 2019 at 12:58 pm #4969 MikhailModerator The new formulas for moving (rolling) averaging are shared here. Thanks a lot to Horacio for sponsorship. Author Posts Viewing 6 posts - 1 through 6 (of 6 total) You must be logged in to reply to this topic.