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.
Time limit: 1 m.
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.