Our full technical support staff does not monitor this forum. If you need assistance from a member of our staff, please submit your question from the Ask a Question page.


Log in or register to post/reply in the forum.

RTMCPRO Averaging over time without Zero values


AnDo Feb 9, 2020 12:05 PM

Hello,

we are collecting wind data including wind gusts.The actual Wind gusts are stored in the table 1 as a value. 

How can I display the averaging of the last 10 minutes without excluding the zero values? 

At the moment I have the expression as follows:

AvgRunOverTime("Server:LOGGER1.MinTable.WindGust1",Timestamp("Server:LOGGER1.MinTable.WindGust1"),nsecPerMin*10)

But with this formula I get false results because the 0 values are included in the calculation. 


Dana Feb 12, 2020 09:54 PM

If it would not affect your data where it is used elsewhere, you could write the datalogger program to store all 0 values as NAN in the data table. The documentation for the AvgRunOverTime states that all NAN, INF, and -INF values are ignored by the function.

However, having a 0 reflected as a NAN may not work for your other uses.

Best, Dana W.

Log in or register to post/reply in the forum.