Riemann sum decreasing value

Configuration
1

I use a Riemann sum to calculate the solar energy produced by my Huawei solar

- platform: integration
  source: sensor.input_power_with_efficiency_loss
  name: solar_energy_riemann_k
  unit_prefix: k
  round: 3

        - name: "input_power_with_efficiency_loss"
          unique_id: "input_power_with_efficiency_loss"
          unit_of_measurement: "W"
          device_class: power
          state_class: measurement
          state: >-
            {% set inverter_rating = 6000 %} {# adjust this value to the rated power of your inverter #}
            {% set inpower = states('sensor.inverter_input_power')|float(0) %}
            {% if inpower < (inverter_rating*0.1) %}
              {{ inpower * 0.90 }}
            {% elif inpower < (inverter_rating*0.2) %}  
              {{ inpower * 0.95 }}
            {% else %}
              {{ inpower * 0.98 }}
            {% endif %}

Sometimes, not everyday, I get a negative value solar production.
Errore_riemann

In this case the riemann sum last value before the “drop” was 2653.76, then it changed to 2650.58. This caused the solar production to start with -3.xx kWh

May

image
image1268Ă—374 22.5 KB

Could it be related to the integrated sensor “input_power_with_efficiency_loss,” which, as shown in the screenshot, has some negative values at the beginning and end of the day?

Is it possible to ensure that this sensor only generates values greater than or equal to zero? I’m not sure if using the availability template would yield the same result.

2

it’s because you’re using float(0) on inpower which causes the template to evaluate to zero when 'sensor.inverter_input_power' goes unavailable.

use this template sensor instead.

        - name: "input_power_with_efficiency_loss"
          unique_id: "input_power_with_efficiency_loss"
          unit_of_measurement: "W"
          device_class: power
          state_class: measurement
          availability: >
            {{ states('sensor.inverter_input_power') | is_number }}
          state: >-
            {% set inverter_rating = 6000 %} {# adjust this value to the rated power of your inverter #}
            {% set inpower = states('sensor.inverter_input_power') | float %}
            {% if inpower < inverter_rating * 0.1 %}
              {{ inpower * 0.90 }}
            {% elif inpower < inverter_rating * 0.2 %}  
              {{ inpower * 0.95 }}
            {% else %}
              {{ inpower * 0.98 }}
            {% endif %}
1 Like
3

Thank you!!

4

Hi @petro , unfortunately the problem is not solved.

image

image
image1338Ă—520 26.5 KB

I’m using your code

        - name: "input_power_with_efficiency_loss"
          unique_id: "input_power_with_efficiency_loss"
          unit_of_measurement: "W"
          device_class: power
          state_class: measurement
          availability: >
            {{ states('sensor.inverter_input_power') | is_number }}
          state: >-
            {% set inverter_rating = 6000 %} {# adjust this value to the rated power of your inverter #}
            {% set inpower = states('sensor.inverter_input_power') | float %}
            {% if inpower < inverter_rating * 0.1 %}
              {{ inpower * 0.90 }}
            {% elif inpower < inverter_rating * 0.2 %}  
              {{ inpower * 0.95 }}
            {% else %}
              {{ inpower * 0.98 }}
            {% endif %}