2 Replies Latest reply: Sep 28, 2012 3:25 PM by Laurent DOURNAUX RSS

    How to write a set analysis expression using a range of date?

      Hi all,

       

      I want to write a set analysis expression that could count  a number of client between 2 fiscal year.

      I tried this :

       

      sum({$<FiscaleYear={'>=2010'}, FiscaleYear={'<=2012'}>} NumberClient)

       

      but it sums all the client before 2013 and all the client after 2009.

       

      What I want is the number of client between 2010 and 2012.

       

      Do you have any ideas?

       

      Many thanks