Hello, Thank you all for this training system! I am very excited to move forward with all of the training modules that are relevant to my current needs. The first one that brought me here was the Scenario Analysis learning path and I plan to work with the rest of the inventory, budgeting and sales modules as I move forward through the training paths.
I have had great success with all of the calculations and measures, but I am having one issue that I am hoping for assistance with. In fact, what I have been able to create so far is a GAME CHANGER!!
That said,
I can get all of the various scenarios to calculate properly, and I have made several other scenarios and measures using your measures as a base. The issue is when I create a Scenario measure for Gross Margin % of Gross Sales. This is based off of Scenario Profits as shown here, and unfortunately increases with demand. Where the Profit should increase, the GM% should stay the same unless the Cost measures change. Do you have any suggestions on how I can calculate for this? If I am just not far enough through the course or if there is another module this is explained in - please just let me know and I will dig in.
Scenario GM % of GS = DIVIDE([Scenarios Profits], [Selected Scenario Sales], 0)
Thank you!