View Only

 Fareinheit to celsius conversion

  • Pentaho
  • Pentaho
Muhammad Adeel Khan's profile image
Muhammad Adeel Khan posted 07-24-2019 00:04

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

Johan Hammink's profile image
Johan Hammink

Just calculate it with for example a formula step


David da Guia Carvalho's profile image
David da Guia Carvalho

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


celsius (A * B)  pre_celsius * convertion_ratio

Calculator usually gives better performance them scripts.