Discuss challenges in energy and automation with a global network of peers.

39794members
181071posts

Is this the only way to calculate a rolling 12 month total?

Lieutenant

Is this the only way to calculate a rolling 12 month total?

(SUM PER MONTH LAST MONTH ([Electricity:ENERGY])+

SUM PER MONTH 2 MONTHS AGO ([Electricity:ENERGY])+

SUM PER MONTH 3 MONTHS AGO ([Electricity:ENERGY])+

SUM PER MONTH 4 MONTHS AGO ([Electricity:ENERGY])+

SUM PER MONTH 5 MONTHS AGO ([Electricity:ENERGY])+

SUM PER MONTH 6 MONTHS AGO ([Electricity:ENERGY])+

SUM PER MONTH 7 MONTHS AGO ([Electricity:ENERGY])+

SUM PER MONTH 8 MONTHS AGO ([Electricity:ENERGY])+

SUM PER MONTH 9 MONTHS AGO ([Electricity:ENERGY])+

SUM PER MONTH 10 MONTHS AGO ([Electricity:ENERGY])+

SUM PER MONTH 11 MONTHS AGO ([Electricity:ENERGY])+

SUM PER MONTH 12 MONTHS AGO ([Electricity:ENERGY]))

SUM PER YEAR only does it over the calendar year right? This seems to be a very calculation intensive way & as such it take a fair while to load.