Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Thanks!
Yes it will because it is a search string
Missing an equal sign
Sum({<Reps = {"=Count(Engagements)>1 and Count(Engagements)<2"}>}Sales)
Yeah..
Thanks Sunny for pointing it out. I forgot.
But will set analysis accept the and operator?
Yes it will because it is a search string