Skip to Content
0
Feb 03, 2023 at 03:59 PM

Help understanding SUM vs. AVG at request level?

214 Views

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!