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

YTD Dynamic Calculations in ASO cubes

Summary:

Dynamic Member Formula not calculating correctly for YTD view.


Content (required):

I have a dynamic calculated account with a member formula that takes two accounts and divides one by the other. All accounts are set to flow account. The values calculate correctly for each specific period in periodic view, but for YTD view the ratio accumulates prior months rather than calculate an ratio based on the YTD values of the accounts that make up the formula. Illustration attached. I've tried changing the account type of the dynamic calculated member from flow to weighted average - actual 365 and weighted average - actual and also average but still not getting the desired

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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