9 Replies Latest reply: Apr 2, 2017 11:31 AM by Ramzi Manoubi RSS

    Set Analysis: most recent, earlier than a date

    Ramzi Manoubi

      Hello, I really hope someone can help me with this one. Any help is welcome.

       

      Context:

      Sales representatives do registrations when they visit the points of sales (stores).

       

      The goal:

      When you pick a date, the max date is calculated. I want to use this date as a date picker.

      Per customer I want to have the most recent registered value prior to this date.

       

      QVF with clarification as attachment.

       

      If something is not clear, please ask.