Count List

[Domearian]

I am trying to create an autmation Bot that sends a notification if any documents have a "due for renewal" date within 30 days. The expression I am using is this:

COUNT(LIST(Documents Due within 30 Days))>=1

When I view the table running the slice [Documents Due within 30 Days] nothing is shown but the automation condition comes up "Y" when tested. How can this be when there are no documents due for renewal within 30 days?

If I enter >=2 then it comes up "N", but >=1 should come up "N". So I am confused.

[dbaum · Accepted solution]

---

@Domearian wrote:

COUNT(LIST(Documents Due within 30 Days))>=1

---

This syntax doesn't make sense. If "Documents Due within 30 Days" is a slice, then try one of the following:

COUNT(Documents Due within 30 Days[Column])>=1

ISNOTBLANK(Documents Due within 30 Days[Column])

[Domearian]

Thank you. I had tried that but now it seems to work. Thank you again.