How does AF Rollup analysis handle bad data? For example, if I would like to sum/average/max oil flow of wells, how does AF rollup analysis handle bad data? The oil flow attribute is mapped to PI Tag. If one of oil flow has bad data, I do not want to sum those values.

Hi Kristy

Bad values in event-weighted calculations are completely excluded from the calculation. Since event-weighted calculations are just simple arithmetic calculations, the exclusion of these bad values has no effect on the final outcome of the calculation. For example, the total and average of the set of values, '5, 6, 3, "I/O Timeout", 2, 4', will be calculated as 20 and 4 respectively.

To understand how TagTot, TagAvg works, request you to check the link :

KB01585 - How Time-Weighted and Event-Weighted Totals and Averages Work

Regards,

Lal