Support Board

• Support Board |
• Search Board |
• Control Panel |
• View My Posts / Threads |
• Direct Messages

Date/Time: Tue, 30 Jun 2026 15:06:44 +0000

Post From: Issue using AVERAGE function to compare delta to previous values

[2025-08-12 13:23:15] Link To Thread - Link To Post [Go To First Post]
User431178 - Posts: 888
=AND(ID5.SG1 < (=AVERAGE(ID5.SG1[-1:-4]) * -2) This errors due to the extra = prior to the average =ID5.SG1<(AVERAGE(ID5.SG1[-1:-4])*-2) This seems to work as expected, see image. - Grey bar = condition met - value on high = delta - value on low = delta[-1:-4] * 2
1 Thank you
alert.png / V - Attached On 2025-08-12 13:19:55 UTC - Size: 127.9 KB - 140 views