Thanks for the reply re LAG/LEAD functions. Apparently those are already turned on in our system. So, using your formula without the 'AVG' wrapper works to populate a column, BUT I cannot get it to aggregate. If I add the AVG wrapper it breaks the function. If I use it without the AVG, I can get it to show in a table…
Thanks Grant That's all (and exactly what) I needed!