SALESFORECASTQTY Key figure question

[former_member1161731]

In the SAP1 model, SALESFORECASTPRICE equals SALESFORECASTREV/SALESFORECASTQTY for a non-zero SALESFORECASTQTY value. The calculation for SALESFORECASTREV shows a  calculation of SALESFORECASTQTY * SALESFORECASTPRICE @ PERPRODCUST.

Two questions:

1. It seems like SALESFORECASTPRICE is dependent on SALESFORECASTREV and vice versa in a interdependent relationship. Why is that so?

2. SALESFORECASTPRICE is a stored key figure. So, why does it have a calculation for it?

[Irmi_Kuntze · Accepted solution]

SALESFORECASTPRICE is stored and not calculated, and editable. And there is no formula on base planning level.

There is only a formula on request level, and the purpose of request level is to provide the aggregated information.

For prices you always have the problem than you cannot sum them up.

If you would simple provide an avererage, in most cases that is not enough.

For example, if in Excel you are on productgroup-country level, but your prices would be maintained on product-customer level, your SALESFORECASTREV would be correctly calculated at lowest level product-customer and than aggregated up to productgroup-country level.

But the price you would see would be non-weighted, so if on agregated level you would devide SALESFORECASTREV / SALESFORECASTQTY the result would be different from what you see in SALESFORECSTEPRICE

For that purpose, the requestlevel calculation of the price is the formula for a weighted average

And the weighting is done with the salesforecastval/qty

Disadvantage of that formula is, tha in case you dont have a qty the price does not show even if something is available. But if that would be needed it could be solved by a helping KF and a slight adjustment of the averaging formula as well

YOurs

Irmi