Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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')
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')