Files:
CFE4130
Offline
Last seen: 1 year 1 month ago
Joined: 08/05/2019 - 12:59
Is this for the entire file or certain groupings. If you want to obtain the lower amounts you can use the Top Records Extraction (it also does the bottom records) and extract the records that way. If you are trying to remove them from your file then you could add on a record number field, do the bottom record extraction and then do a join based on the record number with the original file to remove those transactions using the no secondary match option.
It would be based off of certain groupings such removing the lowest amount for each staff member for each date.
You then would run the top records extraction with the type being Bottom Records, Bottom Records for would be the amount field and the grouping would be staff member and date.
You would then take your main file and join it to the bottom records you created by the record number field and select no secondary matches which will remove all the items from the bottom records file from your source file. Make sure you validate the bottom records file to make sure that you are getting the items you expect.
Good luck in your project.
Brian,
I finally had time to attempt this today. Your explanation made it simple. Thank you so much for your help.
That is great, thanks for letting me know.