Help understanding SUM vs. AVG at request level?

[mark_j]

Beginner trying to understand better how key figure calcs work; the model config doesn't go into too much detail about this.

This question seems simple but I suppose I am overcomplicating my thought process.

Say I have:

KF1@REQEST= AVG(KF1@MTHPRODLOC).

KF1@MTHPRODLOC = KF2 / KF3

The outputs I am seeing in IBP don't make sense to me; can someone explain what AVG is actually doing at the request level? I don't understand how aggregation would take place if I'm only working within a single planning level (for example, no planning levels rolled up with weeks for given calculation). SUM makes a little more since as the calculation seems to translate as I'd expect (e.g. 1+2=3 for KF2,KF3,KF1).

Thank you!

[Irmi_Kuntze · Accepted solution]

REQUEST level is the level you display in Excel or Planner Workspace

So if you have your base planning level MonthProdLoc, and you have your product in 2 locations, and at the base planning level your product has value 400 in location A and 600 in location B, then:

- With AVG your result on Request level (you display only the product but aggregate over the location) is 500

- With SUM your result on Request level is 1000

Yours

Irmi

[mark_j · Accepted solution]

Thank you Irmi!