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

Percent of sales

Received Response
10
Views
3
Comments
edited Aug 2, 2018 2:36AM in Essbase 3 comments

Summary

Percent of sales

Content

Hi Experts,

I have a scenario where Budget and Percent_of_sales are scenario members, and the requirement is Percent_of_sales should be calculated from budget for every account member by Parent3 member of account dimension as shown below.

                 Budget   Percent_of_sales

Parent1     3000    Parent1/Parent3;

A1             1000       A1/Parent3 

A2             1000       A2/Parent3

A3             1000       A3/Parent3

Parent2      3000    Parent2/Parent3;

A4             1000       A4/Parent3

A5             1000       A5/Parent3

A6             1000       A6/Parent3

Parent3      6000    

I have written the formula as below

Percent_of_sales = "Budget" / @PARENTVAL("Account","Budget");

But it is calculating from its immediate parent(Ex:- A1/Parent1,  a4/Parent2) but all the members need to be divided by Parent3 member.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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