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

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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