ASO member formula to calculate beginning balance as a period (month)
SummaryASO member formula to calculate beginning balance as a period (month)
Greetings. I am seeking help with a formula on an ASO cube that would solve a huge problem for me.
I have an ASO cube with a dimension called "Month". This contains beginning balance plus the 12 months. Year is in a separate dimension called "Year". Pretty straightforward.
Our beginning balance value is a problem because of how I need to load data. I won't get into the particulars; suffice to say that beginning balance is wrong in many cases. It does not equal the prior year beginning balance plus prior year activity (months 1-12).