In my VBA code, I am using the PIPoint.data.Summary function to get an event weighted average. I notice that this function includes all values. Is it possible to exclude/filter out some values? If not is there another function I could use to exclude values?
The reason for my ask, I'm trying to calculate the average voltage over a six month period and I want to exclude any power outage where the voltage equals zero.