Expression error

[#1]

Hi!

Can you maybe help me to correct this expression pls?

=count(DISTINCT(count(distinct{$<Year ={2010}, Month =
{'11','12'}>} Name)+count(distinct{$<Year ={2011}, Month = {'1','2','3'}>} Name)))

I want to count the number of the names from 11/2010 to 3/2011. But I dont know how to write this expression without count  two times the same name in this period.

Any suggestions greatly appreciated.

Andrea

[swuehl · Accepted solution]

Maybe like this:

=count( {$<Year ={2010}, Month ={'11','12'}>+<Year ={2011}, Month = {'1','2','3'}>} Name)

Or select the range on a YearMonth field, maybe with a search expression like

=count( {$<YearMonth= {">=201011<=201103"}>} Name)

[#3]

Thank you so much for ypur help!