Incorrect value comparing chart

[enboer]

I have collect the day energy generated from the solarinvertes 2 times per hour. Hour values and day values are correct. However the value in the comparing chart is not correct, see the pictures.

ChartValue.jpg (83.33 KiB) Viewed 394 times

dayvalues.jpg (36.55 KiB) Viewed 394 times

If I sum the values it is about 150 and the sheet shows 89. I cannot find the logic where this 89 comes from.

I do the same by collecting the total generated power from the solarinverter so from the start in the charts from this devices the values are ok.
The difference between the values from the inverter that the Day value starts at 0on a day, whereas the TotalValue is a continues number, so not reseted to 0 every day.