Ok I’ve done so more reviewing here, and it’s honestly just a bit too much info and is really pushing into consulting which is not really what the forum is all about.
Can we really drill into the formula or table where this is a problem.
Maybe even simplify this down to some simple tables and refined data. Just so we can drill into the specific scenario you’re looking to solve.
At the moment I’m just find it difficult to work out where I’m meant to be looking. There a lot of table, a lot of data, overly complex formulas…so hopefully you can see why I’m a bit confused.
My big suggesting just in general here is to really look to simplify this. It’s just not helpful to yourself attempting to work out what’s happening when your having to work out formulas like this.
It’s almost impossible in my opinion.
I would be relatively confident there is a simple solution to this, but I would like to just see a simplified scenario of it, so that I can get my head around it better.
Thanks
Sam