﻿ Numeric functions
 Numeric functions
 Function name: Usage: Abs Abs (num) Returns the absolute value of a number. Add Add (num, num...) Takes a list of numbers and adds them together.  Missing data is not counted. Avg Avg (num, num ...) Takes any number of values and averages them, ignoring no data. Max Max (num...) Takes a list of numbers and returns the biggest one. Min Min (num...) Takes a list of numbers and returns the smallest one. Number Number (Str) Returns the number stored in the string, str.  Returns 0 if the string is not a number. Sqr Sqr(num) Returns the square of the given num. AsString AsString(number[, precision]) Converts a number to a string, numtrail is the number of digits following the decimal point. This is the simpler version of AsStringF().  AsString() uses the "f" format type, no Width, and optional precision. AsStringF AsStringF( number, FormatString ) Converts a number to a string.  FormatString looks like "%[Width][.Precision]Type   Width is the number of digits to the left of the decimal point.  (spaces will be used if no significant digits are available) Precision is the number of digits to the right of the decimal point. Type is one of: e  = Scientific f  = Fixed g  = General m  = Money n  = Number (floating)   Examples:   AsStringF( 123.456, "%e" ) = 1.2345600000000E+002 AsStringF( 123.456, "%f" ) = 123.456 AsStringF( 123.456, "%.1f" ) = 123.5 AsStringF( 123.456, "%.2m" ) = \$123.46   Note: Any text in the format string that is not part of the % specification will be added as a string literal:   AsStringF( 123.456, "Hello %.1f world" ) = Hello 123.5 world AsStringIntF AsStringIntF( number, FormatString ) Converts a number to a string.  FormatString looks like "%[Width][.Precision]Type   This function begins by rounding the "number" value to create an integer type.  The formatting is the same as AsStringF(), but the possible format types are different since the value is not floating point.   Width is the number of digits to the left of the decimal point.  (spaces will be used if no significant digits are available) Precision is the number of digits to the right of the decimal point. Type is one of: d  = Decimal (integer) u  = Unsigned decimal x  = Hexadecimal   Examples:   AsStringF( 123.456, "%d" ) = 123 AsStringF( 123.56, "%d" ) = 124 AsStringF( 11, "%x" ) = B AsStringF( 255, "%x" ) = FF   Note: Any text in the format string that is not part of the % specification will be added as a string literal: AsStringF( 123.56, "The value is (%d)" ) = The value is (124)