Count excluded values

[p_noindl]

Hi,

I have to show the number of customer visits by month and number of not visited customers. Because I have several facts (sales by customer and date,..) to show,  it is necessary to make selections by year and month, but have to show the total number of not visited customers within a certain period (total 5 customers, 2 visited, 3 not visited).

Anyone has an idea?

Best regards

[maxgro]

visited + not visited is always 5?

not visited is all - visited

count({1-$} DateVisit)

[bgerchikov · Accepted solution]

Try expression below for not visited:

count({<Year=,Month=,CustNo=E({$<CustNo={"=count(DateVisit)>0"}>}CustNo)>} DISTINCT CustNo)

or

count({<Year=,Month=,CustNo=E(CustNo)>} DISTINCT CustNo)

[p_noindl]

It worked, many thanks!