I have a formatting rule with this conditional expression:
count( select([manholes][key] , [hose pull] > 30) ) > 0
When testing from the expression assistant, it returns true for the appropriate records, but it does not change any formatting. However, I made a copy of the rule, and changed the condition expression to:
[hose pull] = true
and added a new [hose pull] VC with a similar expression:
IFS( count( select( [manholes][key] , [hose pull] > 30 ) ) > 0 , true)
And that rule successfully changes the formatting. Whatโs going on here?
Iโm able to successfully use singular derefs in format rules, so perhaps this is specific to bulk derefs?
User | Count |
---|---|
16 | |
10 | |
9 | |
8 | |
3 |