Sample configuration for aggregation of standard deviation
Take the sum of the squares; then calculate the square root of the total:
Calculate the squares:
Square the values:HKF1@PL = PROPAGATEDDEMANDSTDEV@PL ** 2
Sum the squares:HKF1@REQUEST = SUM(HKF1@PL)
Calculate the square root of the total:PROPAGATEDDEMANDSTDEV@REQUEST= HKF1@REQUEST ** 0.5
The ISNULL condition works only when an underlying time series record exists for the planning object.
Imagine that Sales Forecast Quantity and Marketing Forecast Quantity are the stored key figures for planning level PERPROD.
Key Figure: Sales Forecast Qty
Key Figure: Marketing Forecast Qty
With the above data, IF(ISNULL(SALESFCSTQTY),1,0) exhibits the following behavior:
January 2018 has the value “100”.
The planning object for the time period February 2018 does not exist.
Though there is no value for Sales Forecast Quantity, the Marketing Forecast Quantity key figure (for the same planning level) has a valid value. Therefore, a record exists in the time series for this planning object.