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. 


  • 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