YTD Dynamic Calculations in ASO cubes
Dynamic Member Formula not calculating correctly for YTD view.
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