Forum Discussion

amotto11's avatar
amotto11
Helper II
8 years ago

Counting a Rank with Conditions

I have, what i see to be, a very complex problem that i can't seem to even get started with. In my simple example i have 2 tables. One that contains insurance quotes. The table is broken into policyl...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

When all companies are selected, why should Companies D and F not show up.  They have a count of more than >1.  Also, if Companies D and F are selected, why should the Rank be 1 for both?

  • amotto11's avatar
    amotto11
    Helper II
    8 years ago

    Ashish

     

    Your first point is correct, and i have changed my original post to reflect that. With no companies selected, any that are included in the quotes should show up with a quote count, regardless if they have a rank 1. To your second point, why are D and F both Rank 1 when only they are selected. The reason is that Company D is on all 3 quotes, but company F is only on quote 2 and 3. So with the criteria of >= 2 companies being on a quote, only quotes 2 and 3 would be acceptable. Company F beats Company D on quote #2 but company D beats company F on quote #3, so each has one rank 1. I hope that helps.