Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Problem with aggregating percentage values against custom created Scenario — Cloud Customer Connect
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
13
Views
5
Comments
edited Jun 9, 2021 2:17PM in Planning 5 comments

Content

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.

Register

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