2 Replies Latest reply on Jun 2, 2012 7:30 PM by rishi.misra

    In appointment data, I'm trying to identify customers (by id) who have "No Showed" in the past so that I can flag any appointment's for today where a customer has previously "No Showed"

      So here's my data structure:

       

      Tab name: Today's appointments

       

      Customer id       TODAY's Appointment start time

       

      My data also has a field called "IsNoShow" which tallies the number of previous "No Shows" for each customer. Here's the challenge - how do I flag customer's who have "No Showed" in the past for Today or Tomorrow's appointments?