Sum in SetAnalisys

[Marcoimp]

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.

[swuehl · Accepted solution]

It looks quite ok to me. I would probably do a DISTINCT count, though.

What do you mean with 'doesn't work'? No result? Wrong result?

Have you double checked all field names, that they are correctly spelled?

[Marcoimp]

I find, my error. There's a fieldname with a "S" more (VALSALE not VALSALES).

It's strange it gives Zero, anyway......

Thank you.