Support Board

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

Date/Time: Mon, 08 Sep 2025 21:08:50 +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: 772
=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
1x Thank you
alert.png / V - Attached On 2025-08-12 13:19:55 UTC - Size: 127.9 KB - 22 views