'Power to kWH' doesn't work on negative value

CT1 is my ‘Grid Feed’ which is a positive value if I am using more power than my solar pv is generating. It’s negative if my utilisation from appliances is less than I am generating (I am feeding power back into the grid).

When it’s negative, the kWh value is not correct.

AFAIK -997 watts should be -0.997.

Have I done something wrong?

I’ve been doing a lot more reading and it turns out that ‘Power to kWH’ is accumulative. So it’s basically just continually adding. I thought it would be reading the original feed, converting it then storing it in a time series.

I’ll keep reading.