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

[#1]

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

[v_iyyappan · Accepted solution]

Hi,

Try like this

Sum({<FiscaleYear={>=(2010))<=(2012)}>} NumberClient)

Iyyappan

[#3]

Yes it is working, I just remove a ')'

Sum({<FiscaleYear={>=(2010)<=(2012)}>} NumberClient)

Thank you