4 Replies Latest reply: Sep 25, 2017 10:02 PM by lyn de guzman RSS

    How to make the figures unique?

    lyn de guzman

      sample.jpg

      The sample data is for 01 Jan 2017. The ID number 2021333262 ride a shuttle twice on that day that is why there are two "Inbound" data. He has a record of 1,050.11 for 01 Jan 2017, however, this figure should only appear once and not double. What should we do in order to only have one record of 1,050.11 but still there will be two inbound data? Thank you so much.