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?