Set Analysis - Advanced Search

[vkish16161]

All,

I have a scenario like this:

I want the sales of reps where reps have No. of Engagements between 1 and 2.

For this I want to write something like this..

Sum({<Reps = {"Count(Engagements)>1 and Count(Engagements)<2"}>}Sales)

Is this syntax correct?

stalwar1‌

Thanks!

[sunny_talwar]

Missing an equal sign

Sum({<Reps = {"=Count(Engagements)>1 and Count(Engagements)<2"}>}Sales)

[vkish16161]

Yeah..

Thanks Sunny for pointing it out. I forgot.

But will set analysis accept the and operator?

stalwar1‌

[sunny_talwar · Accepted solution]

Yes it will because it is a search string