topic Metric to Imperial Calculation in CMS Development

Metric to Imperial Calculation

ben-duchy — Thu, 30 Sep 2021 10:30:07 GMT

I've have some data in HubDB that represents a metric measuremnt in mm for example 3174. A calculation then converts it to feet and inches;

{% set metric = (row.gf_kitchen_met_1) %} {% set imperial = 304.8 %} {% set calculation = (metric / imperial ) | round (1, 'floor') %} Original = {{row["gf_kitchen_met_1"]}} Converted = {{ calculation }}"

The example above correctly shows 3174 converted to 10.4

Is there a way to show the converted number with the correct symbols, i.e. 10'4" ?

Re: Metric to Imperial Calculation

ben-duchy — Thu, 30 Sep 2021 10:41:40 GMT

I figured it out using the 'replace' function 😀 ...

New calculation = {{ calculation|replace('.',''') }}"

Re: Metric to Imperial Calculation

dennisedson — Thu, 30 Sep 2021 13:24:32 GMT

Solved in 11 minutes from initial post to answering yourself. 🏍

Re: Metric to Imperial Calculation

ben-duchy — Thu, 30 Sep 2021 15:31:28 GMT

Well sort of @dennisedson. I've had another look at the above and it's only caluclating the 'ft' not inches. Howver using the below is a lot more accurate...

{% for row in housetype_db %}  {% set inches = (row.gf_kitchen_met_1 / 25.4) %} {% set feet = (inches / 12)|round(0, 'floor') %} {% set measurement = (inches % 12)|round(0) %}  {% if measurement >= 12 %} {{ feet + 1 }}'0" {% else %} {{ feet }}'{{ measurement }}" {% endif %} {% endfor %}