Hi, I am doing some calculations where I am referring to prior periods. Specifically, I am creating an indicator that sums values on the same hour of the day for the prior "n" days. My results seem a little inconsistent, so I have a question.
I am using 15 minute data and the database is configured with 15 minutes as the base time interval. So, when I say Ref(C, -96) and there is some missing data at, say, -50 to -52, am I going to get the value of C 96 periods prior (24 hours * 4 15 min intervals) or am I going to get the value of C 99 periods prior because 3 of the intervening intervals had no data? - Kevin
