I think this just demonstrates the inventory quantity columns need to be as straightforward as possible. No magical behaviour, no exceptions. Just something that everybody can easily understand and troubleshoot.
It does work almost the same way as @Minaji suggested.
Have a look how it all works in the latest version and let’s see if we can all settle on this.