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.
Solved! Go to 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 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])
Thank you. I had tried that but now it seems to work. Thank you again.
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |