9 Replies Latest reply: Mar 12, 2014 8:17 AM by Gertye Jhhge RSS

    "ANDMODE" with the additional conditions

      Hello

      I have the task to show customers that have a contract with certain products.

      Here a list of customers and their insurance contracts:

       

      01_.jpg

       

      If I add 2 mandatory conditions on the product - everything works fine.

       

      02_.jpg

      But if I will add the condition on the date of the contract ...

      03_.jpg

      I’ll get this result:

       

      04_.jpg

      But I don’t want to see John Lennon in final list because he did not have any agreements (with products KASCO & OSAGO for a given period 01.01.2014 – 03.04.2014.

       

      I don’t know how to relate agreements and product list "ANDMODE". Does anyone have any ideas? without "set analysis"