How to get total count and standard deviation

New Contributor

How to get total count and standard deviation

Can someone please guide me. I have each SKU and would like to get total count and standard deviation. I can get sum but for 7months of data how can I get total count and standard dev? 

1 REPLY 1
Highlighted
Contributor

Re: How to get total count and standard deviation

Break the standard deviation equation into its parts and solve them bit by bit:

Standard Deviation = Square Root of ( ( each X minus average X) / number of values ).

I prefer to break complex line item formulas into components ... each () is typically a separate line item and they get pulled together into a single simpler formula.  

Average X = (sum of X / number of values)

Number of Values = sum of (If In relevant time range? then 1 else 0)

In relevant time range? = boolean time filter

 

Here is another thread that shows a more elegant way to achieve this in a single line item: 

https://community.anaplan.com/t5/Best-Practices/STANDARD-DEVIATION

 

 

 

Message 2 of 2