Chrism 0 Posted September 8, 2020 Share Posted September 8, 2020 Hi, I have a simple contacts portal in customer list, all works great as expected. I would like to search / calculate if any of the contacts in the portal are a certain 'Type' My simple calculation works, but only seems to look at the top record in the portal, not all of them? Is there something simple I need to change? Contacts::Type = "Admin" Thanks Link to post Share on other sites
comment 1,817 Posted September 8, 2020 Share Posted September 8, 2020 Try: not IsEmpty ( FilterValues ( "Admin" ; List ( Contacts::Type ) ) ) Link to post Share on other sites
Chrism 0 Posted September 8, 2020 Author Share Posted September 8, 2020 Yep sorted! Thanks for you help Link to post Share on other sites
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now