% Mix Calculation

I am looking to create a % Mix calculation to create a line item to bring into one of my app pages. For example, I want to create a column next to 'Locked L52wk CY Vol' that shows the % for each MU of the Region (screenshot below). In the example below for MU - CO MT UT WY I would like to see that 133,729 is 35% of 380,896. Is there an easy way to do this?

Best Answer

  • Anurag0911
    Answer ✓

    There is no screenshot but as per the information present, here are the steps:

    1. Add a New Line Item for Percentage Mix Calculation:
      • Create a new line item and label it as '% Mix'.
    2. Format the % Mix Line Item:
      • Adjust the formatting of the '% Mix' line item to display values as percentages. This modification will transform the decimal values into a percentage format, enhancing clarity and readability.
    3. Define the Formula for % Mix:
      • Implement a formula to compute the percentage mix. Use the following expression: This formula divides the 'Locked L52wk CY Vol' for each MU by the newly created 'Total Volume by Region' line item.

    Hope this helps!

Answers