I want to know how I can create a Set Analysis that counts the active one for example:
I want to count the ID_ACC
Count( if (Date_End >= Var_Date and Date_Start <= Var_Date), ID_ACC)
Var_Date is a Variable calculated by a calendar
And Date_End and Date_Start are Dates in a table.
I will appreciate your help.