ASO Member Formula Sum Help
Hi,
Writing a member formula on the ASO cube where I would like to sum up the quarters and yeartotal as well. The sample code below validates but is not summing the quarters. The Period dimension is basic - BegBal then YearTotal with 4 quarters and their respective level 0 months. No shared members. Not sure what I'm missing here. The rest of this code works as expected for the Balance account members. Any help would be appreciated.
CASE WHEN IsAccType ([Account].CurrentMember, Last) AND IsGeneration([Period].CurrentMember, 3)
THEN SUM(PeriodsToDate([Period].Generations(2), [Period].CurrentMember), [View].[Load])
END
--------------------
Using Q1 as an example, the snippet above is just taking the value from Mar and making that Q1's total.