AnsweredAssumed Answered

Differences between PI Datalink and PI AF calculations

Question asked by HopeS on Feb 6, 2019
Latest reply on Feb 7, 2019 by jyi

Hi All, I am currently reverse engineering some PI Datalink calculations from an Excel spreadsheet into PI AF (Systems Explorer) and am finding that if a filter condition is applied in the calculated sidebar in Excel, the same value cannot be achieved using similar functions in AF. For example, calculating a time weighted daily average from compressed data with a filter specifying the value be greater than 20, a different Average is produced to when applying the same logic in AF. This AF logic being: “ if *value* >20 then *keep* else NoOutput(), writing this filtered data to a new tag and then using TagAvg on that data. Could someone please explain why this happens and how to correct for it in PI AF?