Support Board

Date/Time: Fri, 07 Feb 2025 18:19:49 +0000

Post From: Formula must be too long

[2014-11-09 19:49:00] Link To Thread - Link To Post [Go To First Post]
User28317 - Posts: 149
Below is an alert I built into color bar based on alert. When I put it into the alert, it is too long and only part of it shows. What is the answer =OR(AND(ID10.SG1>ID10.SG1[-1],ID6.SG1>ID6.SG1[-1],OR(ID10.SG1[-2]>ID10.SG1[-1],ID6.SG1[-2]>ID6.SG1[-1])),AND(ID10.SG1<ID10.SG1[-1],ID6.SG1<ID6.SG1[-1],OR(ID10.SG1[-2]<ID10.SG1[-1],ID6.SG1[-2]<ID6.SG1[-1])),AND(ID10.SG1>ID10.SG1[-1],ID4.SG1>ID4.SG1[-1],OR(ID10.SG1[-2]>ID10.SG1[-1],ID4.SG1[-2]>ID4.SG1[-1])),AND(ID10.SG1<ID10.SG1[-1],ID4.SG1<ID4.SG1[-1],OR(ID10.SG1[-2]<ID10.SG1[-1],ID4.SG1[-2]<ID4.SG1[-1])),AND(ID6.SG1>ID6.SG1[-1],ID4.SG1>ID4.SG1[-1],OR(ID6.SG1[-2]>ID6.SG1[-1],ID4.SG1[-2]>ID4.SG1[-1])),AND(ID6.SG1<ID6.SG1[-1],ID4.SG1<ID4.SG1[-1],OR(ID6.SG1[-2]<ID6.SG1[-1],ID4.SG1[-2]<ID4.SG1[-1])))