AnsweredAssumed Answered

PI´s calculation with limit for a certain time

Question asked by pablo77f on Dec 2, 2016
Latest reply on Dec 6, 2016 by pablo77f

Hello!

 

I am working with PI Datalink Macro and i have a problem:

I need to calculate in an Excel file the number of times a variable exceeds a limit and stays in that upper limit for a certain time.

 

Example:

Time limit: 1 m.

Limit: 1.

Result: should be 1.

 

 

I make the following formula but it does not work as expected:

(prevevent('TAG_NAME','* ')<'* -1m') and (' TAG_NAME ' >= 1)

 

Can somebody help me??

Thanks and regards.

Outcomes