The following functions, and their description, are available in the Calculation Builder below
Function | Description |
ABS | Get the absolute of the number |
ACOS | Get the Arc Cosine of the given value |
AND | If all of the conditions are true, return true. If any condition is false, return false. |
ASIN | Get the Arc Sine of the given value |
ATAN | Get the Arc Tan of the given value |
AVG | Get the average (mean) of the numbers |
CDD | Calculates the Cooling Degree Days for the given Ambient Temperature and Base Point Temperature |
CEILING | Get the smallest whole number greater than or equal to the number |
COS | Get the Cosine of the given value |
DAY_OF_MONTH | For the timestamp on the row return the day of the month. |
DAY_OF_WEEK | For the timestamp on the row return the day of the week. |
DEW_POINT | Calculate Dew-point Temperature (°C) from given ambient temperature, relative humidity and atmospheric pressure. If only 2 parameters are provided, pressure defaults to 101.325 kPa |
DRY_AIR_DENSITY | Calculate Dry Air Density (kg_dry/m³) from given dry bulb temperature (°C), relative humidity (%) and atmospheric pressure (kPa). If only 2 parameters are provided, pressure defaults to 101.325 kPa. |
EXP | Returns e to the power of the number supplied. |
FIF | This is a variant on the IF function. If the condition is true, the second value is used. If the condition is false, no value is used. |
FLOOR | Get the largest whole number less than or equal to the number. |
HCOS | Get the Hyperbolic Cosine of the given value |
HDD | Calculates the Heating Degree Days for the given Ambient Temperature and Base Point Temperature. |
HOUR_OF_DAY | For the timestamp on the row return the hour of the day. |
HSIN | Get the Hyperbolic Sine of the given value |
HTAN | Get the Hyperbolic Tan of the given value |
HUMIDITY_RATIO | Calculate Humidity Ratio from given ambient temperature, relative humidity and atmospheric pressure. If only 2 parameters are provided, pressure defaults to 101.325 kPa |
IF | If the first value is true, use the second value, otherwise use the third value |
LOG10 | Get the base 10 logarithm of the number |
LOGE | Get the natural logarithm to the base e of the number |
MAX | Get the maximum of the numbers |
MEDIAN | Get the maximum of the numbers |
MIN | Get the minimum of the numbers |
MINUTE_OF_HOUR | For the timestamp on the row return the minute of the hour. |
MODULO | Get the remainder or modulo of division. |
MOIST_AIR_DENSITY | Calculate Moist Air Density (kg/m³) from given dry bulb temperature (°C), relative humidity (%) and atmospheric pressure (kPa). If only 2 parameters are provided, pressure defaults to 101.325 kPa. |
MOIST_AIR_ENTHALPY | Calculate Moist Air Enthalpy (kJ/kg) from given ambient temperature, relative humidity and atmospheric pressure. If only 2 parameters are provided, pressure defaults to 101.325 kPa |
MONTH | For the timestamp on the row return the month number. |
OR | If any condition is true, return true. If all of the conditions are false, return false. |
POW | Get the first number to the power of the second number |
ROUND | Get the nearest whole number to the number |
SIN | Get the Sine of the given value. |
SQRT | Get the square root of the number |
SUM | Get the sum of number |
TAN | Get the Tan of the given value |
WET_BULB_TEMPERATURE | Calculate Wet Bulb Temperature (°C) from given ambient temperature, relative humidity and atmospheric pressure. If only 2 parameters are provided, pressure defaults to 101.325 kPa |
YEAR | For the timestamp on the row return the year |