Calculate EMP until Year Month ?

[#1]

Hi all,

I want to calculate the number of EMP until the selection Year:

=Count({$<IsActive={0} , Year={">=$(=Min(Year))} <=$(=Max(Year))"} >} EMP) : this expression works but when I clik on Year and Month, I only see the new EMP in my selection.

Example : I select Year 2014 and Month Feb : I want to calculate EMP from Min Year (2000) to 2014-Feb.

=Count( { $ <IsActive={0} , Year= { "<= $(=Max(Year))" } , MonthYear= { "<= $(=Max(MonthYear))"} >} EMP)

Is it possible to have the same expression with Fiels Year and Month without MonthYear ?

Thanks for your help.

[martinpohl]

You have to exclude in the formula in calculating.

=Count( { $ <IsActive={0} , Year= { "<= $(=Max(Year))" } , MonthYear= { "<= $(=Max(MonthYear))"} , Month=>} EMP)

[#3]

Thanks you Martin !!