You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Successive Addition technique when all dimensions need to be looped through - help?

Received Response
32
Views
5
Comments
in Financial Consolidation and Close 5 comments

Content:

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:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!