Ratio of what % each child makes up of parent

mEEhan011
Contributor

Ratio of what % each child makes up of parent

Hello,

 

I am attempting to calculate the % of a parent forecast each child makes up in a given time period.  For example, a month has a 100 unit forecast in America.  Texas makes up 60 units and California makes up 40 units (both children of America in a list).  I am trying to show this: 

 

    Texas 60%

    California 40%

America 100%

 

I am having trouble avoiding the level mismatch error.  Any suggestions on formulas?

1 ACCEPTED SOLUTION

Accepted Solutions
JaredDolich
Moderator

Re: Ratio of what % each child makes up of parent

@mEEhan011 

Love it. Very common question about how to calculate percent to total. Best way when dealing with the TIME dimension is to calculate the numerator and denominator separately. Follow DISCO, in particular, use system modules, try not to recalculate the PARENT in the TARGET module.  Use LOOKUP to get the parent of the product. Use SELECT when you hit the top level.

JaredDolich_0-1638308385493.png

JaredDolich_1-1638308556889.png

 


Jared Dolich

View solution in original post

1 REPLY 1
JaredDolich
Moderator

Re: Ratio of what % each child makes up of parent

@mEEhan011 

Love it. Very common question about how to calculate percent to total. Best way when dealing with the TIME dimension is to calculate the numerator and denominator separately. Follow DISCO, in particular, use system modules, try not to recalculate the PARENT in the TARGET module.  Use LOOKUP to get the parent of the product. Use SELECT when you hit the top level.

JaredDolich_0-1638308385493.png

JaredDolich_1-1638308556889.png

 


Jared Dolich