# Math functions

 FUNCTION DESCRIPTION SYNTAX Abs Returns the absolute value of a number (integer,currency, real, float). Abs(1.5)  -> 1.5 Abs(-1.5) -> 1.5 The parameter can be XPath, variable or number. CHelper.Math.Abs(Number) Average Obtains the average (arithmetic mean) of a set of numbers (integer,currency, real, float). The parameters can be Xpaths, variables or numbers, and have to be between brackets. CHelper.Math.Average([Number1,Number2,......) Ceiling Rounds a number (integer,currency, real, float) up to the nearest integer. Ceiling(1.2) -> 2 Ceiling(1.9) -> 2 The parameter can be XPath, variable or number. CHelper.Math.Ceiling(Number) Exp Returns e (the base of natural logarithms) raised to the given power.   The parameter can be XPath, variable or number. THE RESULT OF THIS FUNCTION MUST BE STORED IN A FLOAT-TYPE ATTRIBUTE. CHelper.Math.Exp(Number) Floor Rounds a number (integer,currency, real, float) down to the nearest integer. Floor(1.2) -> 1 Floor(1.9) -> 1 The parameter can be XPath, variable or number. CHelper.Math.Floor(Number) IsNaN This function checks if a parameter is not a number: •Returns true if the parameter is not a number. •Returns false if the parameter is a number. The parameter can be XPath, variable or number. CHelper.Math.IsNaN(Parameter) Ln Returns the natural logarithm of a number (integer,currency, real, float). The parameter can be XPath, variable or number. CHelper.Math.Ln(Number) Log10 Returns the base 10 logarithm of a number. The parameter can be XPath, variable or number. CHelper.Math.Log10(Number) Max Returns the largest value of a set of numbers (integer,currency, real, float). The parameters can be Xpaths, variables or numbers, and have to be between brackets. CHelper.Math.Max([Number1,Number2]) Min Returns the smallest value of a set of numbers (integer,currency, real, float). The parameters can be Xpaths, variables or numbers, and have to be between brackets. CHelper.Math.Min[(Number1,Number2]) Module Returns the remainder after a number is divided by a divisor. Mod(8,3) -> 2 Mod(10,2) -> 0 The parameters can be Xpaths, variables or numbers and must be integers. CHelper.Math.Module(Number,Divisor) Percentage Returns the equivalent in percentage of a number (integer,currency, real, float). Percentage(100) -> 1 Percentage( 75)  -> 0.75 The parameter can be XPath, variable or number. CHelper.Math.Percentage(Number) Pow Obtains the result of a number raised to a power. The parameters can be Xpaths, variables or numbers. CHelper.Math.Pow(Base,Power) Quotient Returns  the integer portion of a division. Quotient(100,3)-> 33 Quotient(5,2)-> 2 The parameters can be Xpaths, variables or numbers and must be integers. CHelper.Math.Quotient(Number,Divisor) Rand(from,to) Returns an integer random number between two numbers. The parameters can be xpaths, variables or numbers and must be integers. CHelper.Math.Rand(ValueFrom,ValueTo) Rand When the function has empty parameters it returns decimal random number between 0.0 to 1.0. CHelper.Math.Rand() Round(number,decimal) Reduces a given number (integer,currency, real, float) to a specific number of decimal places (integer). Round (1.247,2) -> 1.25 Round (1.534,1) -> 1.5 The parameters can be Xpaths, variables or numbers. CHelper.Math.Round(Number,DecimalPlaces) Round(number) Reduces a given number (integer,currency, real, float) to an integer without decimal places. Round (1.247) -> 1 Round (1.534) -> 2 The parameters can be Xpaths, variables or numbers. CHelper.Math.Round(Number) Sqrt Obtains the square root of a number (integer,currency, real, float). CHelper.Math.Sqrt(Number) Truncate Truncates a number (integer,currency, real, float) to an integer by removing its decimal, or fractional part. Truncate(35.5) -> 35 Truncate(35.89) -> 35 The parameter can be XPath, variable or number. CHelper.Math.Truncate(Number)