This is very complex with everything that’s going on here. I have to be honest it’s tough to understand all the moving parts being relatively unfamiliar with all the data, even though I’ve spent many hours on this now.
I think we just have to work logically through what the calculation is doing in the context of the total and try figure it out from there.
In the total field the SUMMARIZE function is building a virtual table of all the months in that particular context. The only month in the context though is March at the moment
So the table will only be one row.
Average Entrants will then be working out the below
I believe it’s likely to be the SUMX part of this formula.
Which is then jumping back to this part of the formula
This is where I’m lost. It’s way too complex to understand here.
We’re jumping back to about three different branches.
I truly would start again and build this one formula from scratch and not have it jumping between all of these, as I’m sure your struggling to understand every calculation as well.
I would create every calculation you need in the one formula for ‘Forecast Entrants’
This would make the number much easier to audit
Sam