I'm having trouble figuring out how to do this since one is a value and one is an average. I first tried to use a range function for the numerator (which isn't ideal) and an average function for the denominator, but then I found out you can't divide data sets. Any suggestions?

Hello Catherine,

I'm not sure about your goal, but such calculations can be built with PE syntax, even as a calculated tag:

(TagVal('Tagname') - TagVal('Tagname','*-8h')) / TagAvg('Tagname','*-8h','*')

Is that similar like your idea?

Regards,

Janos