3 Replies Latest reply: Aug 14, 2017 10:45 AM by Sunny Talwar RSS

    Set Analysis - Advanced Search

    Vishnu Chakrakishore

      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!