SOLVED
Logic to determine backorder release
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
Kristinbell
7 - Meteor
12-05-2023
12:25 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'm working with two sets of data. The first set has the quantity of products on backorder. The second set is a list of dates when product is expected in. In the example attached, I need to create logic for the recovery date that is highlighted. We're on backorder for 300 and we anticipate receiving 100 a month between January and May. I want to return the 03/1/2024 date as that's when the backorder is expected to be fully recovered. It won't always be the exact number though. Any formula help is appreciated. Or if there's a better way to do it than a calculated field, I'm open to it.
Solved! Go to Solution.
Labels:
- Labels:
- Community
3 REPLIES 3
21 - Polaris
12-07-2023
08:27 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Kristinbell
We can use the Running Total tool
12-08-2023
07:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That's perfect, thank you!
21 - Polaris
12-08-2023
02:37 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Glad to help. 😁
