5 Replies Latest reply on Aug 29, 2018 1:13 PM by Okechukwu Ossai

    LOD with conditionals

    none given

      I have a dataset of marketing solicitations to Users.

       

      My desire is to find the most recent Date of the last purchase of the User for each solicitation.

       

      I built a simple LOD but am lost as to how to impose conditions such as Purchased must be "Y" and max(date) must be less than date

       

      Attached is a workbook.

       

      Thanks!