Set Analysis - Help

[#1]

Hi

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.

Thanks,

[#2 · Accepted solution]

I found a way to do this

by using this expression:

=Num(count(DISTINCT {<DT_END = {">=$(#Var_Dat)"}, DT_START = {"<=$(#Var_Dat)"}>} ID_ACC),'#,##0')