I came across a numeric function today (CEIL) I had never seen before. It got me wondering if there were other functions in SQR that I was not taking full advantage of. The saying goes, "There is more than one way to skin a cat", and it applies here. The function "abs" can be accomplished without the function ABS, but would require a bit of design and coding. Many times, we need these "basic" numeric functions to build something even more complicated.
Below is a list of common and unique numeric functions you may want to incorporate in your coding. All are delivered and documented with Hyperion. (I'm skipping the SIN, COS, Tanget, etc.) These are in groupings of commonality
 ABS  Returns the absolute value. Similar to TRUNC with a value of zero as the second parameter.
 FLOOR  Appears to be like ABS The manual describes it as "Returns a value representing the largest integer that is less than or equal to num_value".
 CEIL  Returns the next highest integer (unless the value is a whole number/integer). The manual describes it as "Returns a value representing the smallest integer that is greater than or equal to num_value".
 ROUND  Rounds a value to a set number of digits past the decimal.
 TRUNC  Returns the value, and will truncate the digits to a set number of digits past the decimal.
 MOD  Returns the fractional remainder. If you divide 7 by 3, the remainder would be 1.
 E10  Returns the value of 10 raised to a given value.
 EXP  Not sure, but returns the value of "e" of a value that has already been raised.
 POWER  Returns the value of x raised by the power of y.
 HEX  Returns a string in the hexidecimal format. The string will begin with 0x
 SIGN  Returns a +1, 0, or 1, depending on the sign of the input value.
 SQRT  Returns the square root.
Examples of each will be coming soon.
