Simple member formula on account not working after DSO
DSO conversion appears to break member formulas
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?