1 2 Previous Next 15 Replies Latest reply on Nov 17, 2016 5:59 AM by John Croft

    How to identify and filter out records based on condition

    Carles Pujol

      I'm trying to identify and filter out records that don't meet a condition, but I'm having some trouble. I'm attaching the file with comments to get an understanding on the problem.

       

      Basically I want to exclude the records where Scheduled < Actual, but I find that when I do this only some of the records are excluded but not the full day when this happens

       

      Can someone help me to see how I can achieve this

       

      Thanks

        1 2 Previous Next