Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
count({$<DEALER=P({$<LISTINGDATE={">REGISTRATIONDATE"}>}DEALER)>}DEALER)
depending on your data model, you may need:
count({$<DEALER=P({$<LISTINGDATE={">REGISTRATIONDATE"}>}DEALER)>}distinct DEALER)
Hi Ometrice!
Steve is right, except he forgot the DEALERSTATUS in his SET expression:
count({$<DEALER=P({$<LISTINGDATE={">REGISTRATIONDATE"}, DEALERSTATUS = {'Approved'}>}DEALER)>}DEALER)
Nice catch!
How do I exclude the counts from the current selection?
Try this:
count({1-$<DEALER=P({1-$<LISTINGDATE={">REGISTRATIONDATE"}, DEALERSTATUS = {'Approved'}>}DEALER)>}DEALER)