SOLVED
Comparing Records in same column and with other columns
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
mfulara
5 - Atom
‎12-23-2023
12:02 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I want to find and create a new column for the records in which Item Code is the same and Location is different, and then compare the value of Days w/o Consumption column for that case. The most value should get the least value's Location name.
Solved! Go to Solution.
Labels:
- Labels:
- Output
2 REPLIES 2
TimN
13 - Pulsar
‎12-23-2023
12:55 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎12-23-2023
05:54 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks tim it works.
