Login Page - Create Account

Support Board


Date/Time: Tue, 28 Oct 2025 08:23:51 +0000



Post From: MAX function in alert condition not working

[2025-10-22 20:56:10]
tecman240 - Posts: 17
I'm working on an alert using the MAX function. My understanding of the docs is that spreadsheet functions like MAX can be used in alert conditions.
Comparing the MAX to a number doesn't work:
= AND(ID7.SG1<ID7.SG1[-1], MAX(ID7.SG1[-1:-6])> 85.1)

but comparing MAX to a study subgraph value works:
= AND(ID7.SG1<ID7.SG1[-1], MAX(ID7.SG1[-1:-6])> ID7.SG1)

What is the correct syntax to compare MAX to a number?

thanks for the help.