Hi All,
We have challan and entry date for the vehicles.. We are trying to find out if the same vehicle has entered again (entry time) between the challan and entry time.
For ex - the vechicle has challan time of 20-07-2018 and entry time of 25-07-2018, and for the same vehicle do we have entry time between the dates, like 21-07-2018 which should not happen...
Veh | Challan | Entry | |
12345 | 05-07-2017 | 07-10-2017 | |
12345 | 06-07-2017 | 06-07-2017 | Flag |
16782 | 02-07-2017 | 05-07-2017 | |
16782 | 05-07-2017 | 05-07-2017 | |
16782 | 05-07-2017 | 04-07-2017 | flag |
16782 | 12-07-2017 | 13-07-2017 |
Best Regards,
Solved! Go to Solution.
Hi @Scheruku,
For each vehicle everytime the Entry Date will be greater in the next row. Here is the formula:
In Multi-row formula tool use below formula grouping by vehicle.
if [Entry]>=[Row-1:Entry] then "" else "Flag" endif
Thanks,
Vishwa
Hi @mceleavey,
Thank you for your help... I was able to run the workflow but it wasn't throwing me the exeptions..for example
Row No 6 has an entry date of dd-mm-yyyy(07-01-2018) but the same vehicle has an entry date prior to it on the above rows... We are saying the vehicle has prior date because it falls between challan and entry time of the that particular row
challan - 23-09-2017 Entry 07-01-2018
The above row has an entry date between these two dates i.e, 05 & 01 ...and these two rows have to be flagged
Veh | Challan | Entry |
B8933 | 29-07-2017 | 30-07-2017 |
B8933 | 26-12-2017 | 27-12-2017 |
B8933 | 30-12-2017 | 31-12-2017 |
B8933 | 02-01-2018 | 02-01-2018 |
B8933 | 04-01-2018 | 05-01-2018 |
B8933 | 23-09-2017 | 07-01-2018 |
B8933 | 08-01-2018 | 09-01-2018 |