I'm working on logic to determine how many days on hand I have of TotInventory versus Requirements. The logic works but it's counting all running requirements even if we've past that date. I'd like to get my data like the screenshot below to make it work. I've got it in this format but I need to zero out the highlighted data. Is there a good way to do this? Then all my downstream logic will work instead of counting past requirements. Aka if the date in the column is past the date in the row, I want to zero out the requirement as it's in the past. I'm going to scale this up to hundreds of thousand product locations though.
Solved! Go to Solution.
@Kristinbell
I did not quite get your logic here, but tried to come out with something similar with your sample output.
