Dear Comunity,
I have actually the following formula and I would to exclude Lead with the word Silver in [Lead.LastName] and Gold in [Lead.LastName].
Below it's my formula
count(aggr(if(year([Lead.CreatedDate]) = year(today()-1) and month([Lead.CreatedDate]) = month(today()-1) and [Lead.OwnerId] <> '0051t000004EGlIBUI' ,1)
,[Lead.Id]))
I tried to add :
and [Lead.LastName] <> 'Silver' but the value decrease from 400 to 0.
Can you help me?
Best Regards,
