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?

Accepted answers

JaredDolich

@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.

All comments

JaredDolich

@mEEhan011

Quick Links

Can you help?

Unanswered questions

Not Able to Join the Level 1 Model Building Course
Hey Everyone, I was trying to learn about the Level 1 Model Building Course, when i log in to my system and click on "Start the course" option its showing training unavailable, Can anyone please help me with this @Dikshant and all?
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…