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

    "ANDMODE" with the additional conditions


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

      Here a list of customers and their insurance contracts:




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



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


      I’ll get this result:



      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"