5 Replies Latest reply: Sep 3, 2013 9:12 AM by Steve Zagzebski RSS

    Set Analysis - Reporting Dates

    Steve Zagzebski

      I am an expression that is working well:

       

      sum({<^CustProducer = {"=[Commission Producer CummPerc]<=$(vRetensionPct)"}>} Commission)

       

      However I need to add a further requirement to the expression.  I have a field called ProdGLMonth and need to add extra filter ot the set analysis that basically does the following:

       

      Where ProdGLMonth is between [Reporting Begin Month] and [Reporting End Month]