Calcualtion of Standard Dev in IBP

[Former Member]

Hi All,

Is there a way we can calculate stddev in IBP key figure calculation?

[somnath_manna]

Hi Vijay,

If you can take a look at SAP standard template "DP 110 Historical Data Cleanse" available in Unified Planning Area.

There are LocalMembers in it for calculating Mean and range as Mean +/- Z x Standard Deviation of Sales History keyfigure.

Formula for cell can be = STDEV.P($RC:$RCn)

Note in Local Members Use Excel Cell References should be ticked when used with Row/Column combination.

Hope this helps.

Somnath