2 Replies Latest reply: Oct 9, 2013 12:34 PM by Marco Imperiale RSS

    Sum in SetAnalisys

    Marco Imperiale

      How can I get the count of clients of this year that the last year bought more than 2500€ of pieces?

       

      I found this formula:

       

      =count({$<

       

           YEAR={2013},

           CONTACTID = {"=Sum({$<YEAR = {2012}>} VALSALES ) >= 2500"}

       

        >} CONTACTID)

       

      But it doesn't work!

      Where I'm wrong?

      Thank you.