Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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