Trying to get most recent date from portal records
I have a calculation that attempts to get the most recent date for a particular category in related records in a portal.
The calc: If(Month from date ≤ 11 and Year from date = this year and category = 7; active; inactive). The calc grabs the 1st(eariest) record in the portal row. I've tried Max(date) which doesn't work.