Calculating averages

Discussion created by formerpigeek on Jul 17, 2009
Latest reply on Jul 20, 2009 by andreas



I am trying to calculate average, minimum and maximum values of a particular tags for a given start and end time in excel.


I am able to do it through PICompDat function which can list all the values for a specific period of time. But that is very ugly process.


I have to eliminate "#N/A" and "No more values:" messages in the column in every single cell for excel to be able to calculate the averages or the maximums which takes time.


Provided I am not missing any tag attribute given in the datalink,


Is there any faster way to get those values?


Please reply