YTD calculation on parent level
Summary:
Wrong YTD calculation at parent level (aggregation before YTD calc)
Content (required):
We are loading balance sheet data YTD except for one account (retained earnings), which is loaded periodically. In our YTD (view dimension) we specified that for balance sheet accounts YTD is equal to the load member and for P&L accounts we have a YTD formula in.
We also inlcuded an exception line in the YTD calculation to calculate the YTD retained earnings, see also below:
IF(@ISMBR("Reatined Earnings"))
(@PRIOR("YTD")-"Begbalance")+"Total Plan"+"Begbalance";
This YTD formula works at the lowest level, but isn't working for the parent member of retained earnings. Because the aggregation takes place before the YTD calculation.
Tagged:
0