Set Analysis

[pageomet]

Hi;

I'm trying to count all approved dealers with a listingdate > registrationdate.  How do I count everything that the current selection excludes?  See formula below:

=count(Aggr(if(Max(TOTAL LISTINGDATE), DEALER) >  REGISTRATIONDATE, DEALERSTATUS = 'Approved' ,DEALER))

Thanks,

Ometrice Page

[Anonymous]

count({$<DEALER=P({$<LISTINGDATE={">REGISTRATIONDATE"}>}DEALER)>}DEALER)

depending on your data model, you may need:

count({$<DEALER=P({$<LISTINGDATE={">REGISTRATIONDATE"}>}DEALER)>}distinct DEALER)

[#3]

Hi Ometrice!

Steve is right, except he forgot the DEALERSTATUS in his SET expression:

count({$<DEALER=P({$<LISTINGDATE={">REGISTRATIONDATE"}, DEALERSTATUS = {'Approved'}>}DEALER)>}DEALER)

[Anonymous]

Nice catch!

[pageomet]

How do I exclude the counts from the current selection?

[Anonymous]

Try this:

count({1-$<DEALER=P({1-$<LISTINGDATE={">REGISTRATIONDATE"}, DEALERSTATUS = {'Approved'}>}DEALER)>}DEALER)