Numeric Functions
 Written by David Vandiver Wednesday, 04 August 2010 13:24 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. Last Updated on Wednesday, 04 August 2010 13:31