I have successfully created an excel report however one device (VELO409) is reporting 7 X larger sum than is shown in the point detail window... I cannot find any reason for this one point to be incorrect. I have removed and recreated the point and the associated named range with no change.
Start: 2018/05/31 18:32
End: 2018/08/28 10:18
Minimum: 0 kW·hrs @ May 31 18:32
Maximum: 0.07 kW·hrs @ Jul 27 04:41
Average: 0.01 kW·hrs
Integral: 109084.5 s
Sum: 847.7 kW·hrs
Log entries: 54767
I and nothing ODD about the config..
It should be reporting 848 but reports 6605.. Any ideas how to find the issue or where to look? I have poured through the excel input file and cannot find any discrepancies or mistakes with the named ranges, everything looks correct.