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

ASO Dynamic Calc member formula not working as expected

edited May 13, 2026 8:38PM in Planning 3 comments

Hi Experts,

I am trying to calculate ASO Dynamic Calc member using below member formula:

Formula for the dimension member called YTD : ([May],[No Week]) + Sum(CrossJoin({Jun:Period.CurrentMember},{Acc1}))

I am trying to pull the number for Jul and want it to be sum of May, Jun and Jul.

The above formula returns May numbers for the member. It seems that only 1st part of the formula (May, No week) is working and the formula is not able to calculate the later piece. Am I missing anything in the code that pulls Acc1 data for Jun and Jul?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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