I have a M/D relationship with Account and a custom object called Associate.
On Associate, I have a formula field called Age with the following formula:
(TODAY() - DOB__c)/365.2425
I also have a formula called Type:
IF(Age__c >= 18, "Adult", "Adolescent")
I'm trying to do a Rollup Summary on Client that will count the # of Adult and Adolescents. But I do not see the field Type to be able to filter from.
Any ideas? Thanks!
3 answers
Date based formulas aren't supported on roll up summaries. This app might help you.
https://appexchange.salesforce.com/listingDetail?listingId=a0N30000009i3UpEAI
