Highlighted
Previous Contributor

STANDARD DEVIATION

Is there any function in Anaplan to calculate Standard deviation. In excel there is a function "STDEV". Need to get the standard deviation for a product across 36months of data. 

1 REPLY 1
Contributor

Re: STANDARD DEVIATION

I haven't seen a function for this, but you can create your own formula. The one I've done to try and work out the standard deviation of weekly sales is: 

 

SQRT(POWER(Sales - WEEKVALUE(Sales) / WEEKVALUE(h_count), 2) / WEEKVALUE(h_count))

 

h_count is a line item I added to show me days in the week. I've colour coded it above to show how the formula has been built up. 

 

Hope this helps