Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 18 May 2024 04:37:57 +0000
Post From: Need help creating an alert
| [2021-11-12 14:03:10] |
| Sawtooth - Posts: 4000 |
|
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
|