Ratio of what % each child makes up of parent

Options
mEEhan011
mEEhan011 Member, ALL USERS, Community Member, Certified Model Builder Posts: 5 Contributor
in Planning & Modeling

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?

Tagged:

Categories