1 Reply Latest reply on Oct 17, 2018 2:16 PM by Lal_Babu_Shaik

    PI Datalink Calculated Data Filtering Problem

    SLethen

      I have a PI tag that I want to calculate time-weighted daily averages over a 1 year period. The tag value should range between 0 and 3000, however the instantaneous data periodically returns values of -999999, which skews the calculated averages.

       

      I've tried using the filter expression 'TagName' > 0 to remove the negative values, however it still returns negative calculated averages, albeit smaller in magnitude (e.g. for a specified time returns -400 instead of -40000).

       

      Am I missing something in my filter expression?