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

Problem with aggregating percentage values against custom created Scenario

Accepted answer
edited Jun 9, 2021 2:17PM in Planning 5 comments


Hello guys,

We have an issue with newly added custom Scenario member (Actual vs SPLY %). This member is supposed to calculate the % of Difference of Actual scenario values of current year and Actual scenario values of the same period previous year, and divide all by the Actual scenario values of the same period previous year i.e. ((&CurrYear->"Actual" - &LastYear1->"Actual")/&LastYear1->"Actual")*100. So we implemented this logic with the member formula, and the problem is that with have aggregation of these %values against Account dimension members which are not level 0, which in this case is not suitable because we want all percentages

Howdy, Stranger!

Log In

To view full details, sign in.


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