<p>Hi, may i check how can i convert values stored in fareinheit to celsius </p><br><a data-tag-text="Pentaho" data-sign="#" class="user-content-hashtag" href="https://hitachi.connectedcommunity.org/search?s=tags%3A%22Pentaho%22&executesearch=true" data-tag-key="70b4436b-4549-4ce3-aa64-4566c7b665c9">#Pentaho</a>

Pentaho

View Only

Muhammad Adeel Khan posted 07-24-2019 00:04

Hi, may i check how can i convert values stored in fareinheit to celsius

#Pentaho

Johan Hammink posted 07-25-2019 04:50

Just calculate it with for example a formula step

([temp_fahrenheit]-32)/1.8

David da Guia Carvalho posted 07-29-2019 13:49

Or use a calculator step...

Define 2 constants:

convertion_ratio = 0.555555556 (5/9)

convertion_ratio_32 = 32

Execute subtraction from fahrenheit field ( temp_fahrenheit )

pre_celsius ( A - B ) temp_fahrenheit - convertion_ratio_32

Multiply

celsius (A * B) pre_celsius * convertion_ratio

Calculator usually gives better performance them scripts.