Hello, I am trying to calculate the variance in number of records of per day in a calculated field. I have been able to calculate the average response per day but can't figure out how to do the variance. Any help would be appreciated!
It'll be something like:
[My Value] -(PREVIOUS_VALUE(1 )* [My Value])
--Shawn