I would like to create a formula-field on account that is a comparison based on any one of group of child objects satisfying a conditional. I am a SQL developer tasked with this challenge so it seems like a very simple thing to do, but I can not find any documentation on grouping cross object in formulas.
Here is my example:
Standard object [Account] has a custom field [Is Customer].
Custom object [Subscription] has a field [End Date] and a field [AccountID].
[Is Customer] should be true if any [Subscription] records with [Subscription].[AccountID] = [Account].[ID] and [Subscription].[End Date] < TODAY().
How do I group all the [Subscription] records by [Subscription].[AccountID] inside the formula-field so that I can compare the max [End Date] to TODAY()?