Hi everyone!

I am having an unexpected result from the Tagavg function. The average is lower than the raw data. Does anyone know what the cause might be?

Configuration:

Attribute1: Value from PI point

Attribute2: Value from a Table

Analysis: Tagavg('Attribute1','*-5m','*')*'Attribute2'*24

Scheduling: every 5 minutesAttribute3: Output from Analysis saved in PI Point

PI SE 2016 R2 SP1

Here what I got after some testing.

Formula DR with DefaultAllowed=1The average function Tagavg() consider the default value in the calculation. In my case, zero, causing a bias to a lower value. Since my average is for 20 or so value, I usually get 4-5% bias.

Formula DRThe average works fine. But the result does not match exactly the average done in Excel Datalink. So it is a new kind of problem...