Hi Anthony Gray, hoping for a bit more help please! I now have an annual RAMetric, not a monthly one. To then calculate the same profile, I was thinking I could use the aggregate per month expression to disaggregate it down to a monthly and then do the calc similarly. Could you please give me any guidance as to what I have wrong with this? Its simple showing up with no value (FYI, client is Scentre shopping centre management & site is Westfield Burwood and the measurement is 'Target NABERS Profile'). [[DisaggregationMethod=>Constant]] (AGGREGATE PER MONTH([[DisaggregationMethod=>LinearInterpolate]]{RAMETRIC([[IntervalCoverage=>Exact]]Target NABERS)}) / SUM PER MONTH LAST YEAR ([Electricity:ENERGY])) * SUM PER _15MINUTES 364 DAYS AGO( [[DisaggregationMethod=>Constant]][Electricity:ENERGY][kWh] ) Where Target NABERS RAMETRIC is an annual summated value. Thanks!
... View more