good morningHow can I in VBA to change color to a value if it exceeds the minimum of 100 for more than 30 minutes
Is this for a ProcessBook display?
If so, have you considered using a Multistate symbol? You can set the multistate to use a performance equation such as:
if TimeGT('sinusoid','*-30m','*',100) >= 1800 then 1 else 0
which means "If sinusoid is greater than 100 for more than 1800 seconds in the last 30 minutes, return 1, else, return 0"
thanks for the reply
It is a "tag" value if it remains above the threshold "100" for more "1800 sec" to change the status "Color" from green to red.
You can set the color by configuring the multistate to be one color from 0-0.99 and then another from 1->infinity. The tag can be whatever you tag you want it to be. Just type the tag name inside the quotes.
Retrieving data ...