Could anyone help me convert this formula to a value template please.
For example 284 lb should equal 20 Stone & 4 Pounds
=CONCATENATE(ROUNDDOWN(A1/14,0)," Stone & ",MOD(A1,14)," Pounds")
Could anyone help me convert this formula to a value template please.
For example 284 lb should equal 20 Stone & 4 Pounds
=CONCATENATE(ROUNDDOWN(A1/14,0)," Stone & ",MOD(A1,14)," Pounds")
Perfect, thanks
{{ (states('sensor.withings_weight_lbs_lee') | float / 14) | round(0, 'floor') }} Stones {{(( (states('sensor.withings_weight_lbs_lee') | float / 14) - (states('sensor.withings_weight_lbs_lee') | float / 14) | round(0, 'floor'))*14) | round(1)}} Pounds