the answer is yes. But it won't be super-simple. You need a calculation or a script that implements your spoken example above. It's just a matter of coding your logic. In order to do that, you will probably need some summary fields that you'll evaluate.
Just about anything you can do manually in FM can be done via a script or function or custom function.
If you use FileMaker Pro Advanced you can create your own formula for a function that does all the things that you want. If you dont have that, like David M wrote you need to create a quite complicated formula inside a new calculated field, or most probably several fields.
If you need help figuring all that out I recommend you to contact one of the FileMaker Platinum Partners with FileMaker 15 Certified Developers. They know what they are talking about and can help through the progress
Notice that you have received two very general responses. There's not much more that can be offered unless you describe how your inventory system works. Some systems generate a new record each time items are added to or removed from inventory and items can be removed from inventory for reasons other than orders (shrinkage) and this might further affect whether an item falls into a particular movement category.
But does your system log each inventory change like that or use a different method?