Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=Sum(if(Aggr(Min(Month([Access Date])), [UserID])= Month(AddMonths(Max(Date),-1)),1,0))
I'm trying to get the count/Sum of the above-mentioned function but it throws me an error
Is your max date supposed to be a global maximum date? Can you try
$(=Month(AddMonths(Max(Date),-1)))