So, I am tracking costs in Energy tab. And today I noticed I spent around 0,14kWh but dedicated cost is -660,93 KN:
Looking at the database, I see that there is correct value for cost in “State” column but “Sum” column is not adding this value and it was reseted to 0, so home assistant thinks that summary of cost is 0,09 KN - 661,02 = -660,93 KN
How can I correct it with UPDATE SQL functions and not to mess whole DB? Also, how come that “Sum” column is reset to 0?
Thanks.