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

Simple member formula on account not working after DSO

Accepted answer
52
Views
11
Comments
edited Jun 6, 2022 8:57PM in Financial Consolidation and Close 11 comments

Summary:

DSO conversion appears to break member formulas

Content (required):

After converting to DSO, multiple member formulas are not calculating correctly. For example, Calc_MonthNumber simply looks at the period member and populates the corresponding month number. Very simple code as follows:

Post-DSO, when I run an ad hoc, I get the following:

For some reason, Jan is the only month that is working correctly. Additionally, it's only working for FCCS_Periodic, not FCCS_YTD.

The same phenomenon is occurring for similar formulas such as Calc_DaysInMonth and Calc_DaysInQuarter. I know I must be missing something obvious, but I can't get it work correctly. Any advice or ideas about a resolution?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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