Hi Anirudh - We want to normalize the sales history by calculating the outliers. The outliers we decided will be: Mean - (Factor) * (Standard Deviation) Mean + (Factor) * (Standard Deviation) For mean, I did the following on the sales history: IF PERIOD(START()) = TIME.'Current Period' THEN MOVINGSUM(Historical Sales, -(Cumulated History Periods), -1, AVERAGE) ELSE 0 With this, I have the MEAN calculated in the current period. But for standard deviation, I need to have the deviation to calculate each sales history in each time bucket with that of the mean. When I remove the time scale, it says START() function is used. So wondering how I can achieve this. Thanks, Regards - Guru
... View more