Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Thu, 26 Jun 2025 16:16:41 +0000

How to Post a Message for Support

Post From: Need help creating an alert

[2021-11-12 14:03:10]
[Go To First Post]
Sawtooth - Posts: 4231
Try this:

=OR(
AND(C<=ID2.SG1[-1],C>ID2.SG1, ID2.SG1[-1]<=ID2.SG1, ID11.SG1>=ID12.SG1, C>=ID15.SG2),
AND(C>ID2.SG1, ID2.SG1[-2]>ID2.SG1[-1],ID2.SG1[-1]<=ID2.SG1, ID11.SG1>=ID12.SG1, C>=ID15.SG2),
AND(C>ID2.SG1, ID2.SG1[-1]<=ID2.SG1, ID11.SG1[-1]<ID12.SG1[-1],ID11.SG1>=ID12.SG1, C>=ID15.SG2),
AND(C>ID2.SG1, ID2.SG1[-1]<=ID2.SG1, ID11.SG1>=ID12.SG1, C<ID15.SG2[-1],C>=ID15.SG2))

Note that each of the AND statements has a transition of one of the conditions,
and it will alert when any of the AND statements make that transition.
Date Time Of Last Edit: 2021-11-12 15:11:44