Hi.

First of all - many thanks for your time. really appreciate it.

Attached is a script to build the UnitsData table with correct data

Attached an excel that shows the calculation steps

Thanks...

Thanks a lot Lutz.

It works like a charm.

Appreciate your effort.

If I may I have another question:

The average shall be calculated like this:

1. for every day in the last 30...

Hi,

Attached is a script to build the tables with data.

(rename to .sql of course).

I tried to do for the start something like:

SELECT Unit.Name, Unit.SerialNumber, Unit.Location, UD.PowerConsumptionValue, LastDate

...