Hi,
I need some help in creating a rolling Standard Deviation for 20 days at one time. So for Example the date is 02/02/18 I want to get the standard Deviation of the values between 02/02/18 and 01/05/18.
I have attached a spreadsheet of how it has been done in excel i just need to calculate the column in yellow.
Thanks,
Ryan
Hi,
Do you have any range of dates that user enters as a prompt or selection criteria?.
you can use Daybetween() to get number of days.
Thanks,
Jothi
Hi,
No there is no prompt so Daysbetween() wouldn't work as i am trying to do a rolling calculation.
Thanks,
Ryan
Add a comment