Skip to Content
Former Member
Nov 16, 2012 at 06:42 PM

Statistical Forecast $ Value (Qty * MSRP) in Planning Table?


How do you configure the Information Structure or Planning Table to calculate a Statistical Forecast $ value by multiplying the Statistical Forecast Qty * MSRP.

When adding MSRP as a Key Figure in the Planning Table we run into aggregation / disaggregation problems. The macro we tried for the calculation also multiples at each level rather than summing from the Material level. We want to use the MSRP by Material and aggregate the values up for all Material Forecasts so we have a representative Statistical Forecast $ value in decision making.

Has anyone overcome this problem?

Help, Help, Help!