Template sensor and filtering out occasional negative results from calculation

[ardysusilo (Ardy)]

- platform: template
  sensors:
    power_house_consumption:
      friendly_name: House Consumption
      unit_of_measurement: "W"
      value_template: >-
        {% set total_consumption = (states('sensor.fronius_house_load') | float * -1) | round | int %}
        {% set tesla_consumption = states('sensor.twcmanager_1524_charger_load_w') | int %}
        {% set house_consumption = (total_consumption - tesla_consumption) | int %}
        {{ ([0, house_consumption, 50000] |sort) [1] }}

See here for explanation-

Limit a value to fall within a range

I found a clever python example for limiting a value to fall within a range and converted it for use in a Jinja2 template. Let’s say you receive a value that must lie within the range of 0 to 100. If the value is less than 0 it should be reported as 0. If the value is greater than 100 it should be reported as 100. Otherwise, report the value as-is. The traditional way is to use arithmetic comparisons to check the value against the range-limits and, with some if-else involved, report the corr…