Successive Addition technique when all dimensions need to be looped through - help?
I have a few rules that need to loop through all the dimension (apart from the obvious ones that are also restricted - View, Scenario, Years, Entity, Period, Currency, Consolidation). The issue I have is which dimension/member to have as the member block around the calculations.
The successive addition techniques only gives me the correct answer if I have an IF statement that does something along the following: IF(@CURRMBR("Movement")->"FCCS_YTD"<> #missing), so I need an IF statement and therefore a block around the calculation.
At the bottom is an example. Effectively, in
the example I am trying to calculate the following: