1. Numeric functions

    Article: AN0002151Updated:

     

    Function name and parameters Function description
    ColorFromRGB(r,g,b) Creates colour according to the values r, g, b
    ColorToInt(c) Converts colour to the integer that can be saved in the column of the colour data type.

    Example:

    ColorToInt(ColorFromRGB(100,100,100))
    CInt(Integer) Converts input value to an integer. (Returned value is data type integer.)
    Power(number, n) Returns b raised to the power of n. (Returned value is data type float.)
    Sin(X) Returns sine of X. X is an angle in radians.(Returned value is data type float.)
    Cos(X) Returns cosine of X. X is an angle in radians. (Returned value is data type float.)
    Tan(X) Returns tangent of X. X is an angle in radians. (Returned value is data type float.)
    Asin(X) Returns arcsine of X. X is sine of the required angle, which has to be in the range of -1 to 1. The result is in raidans –pí/2 to pí/2.(Returned value is data type float.)
    Atan(X) Returns arctangent of X. X is tangent of the required angle, which has to be in the range of -1 to 1. The result is in radians –pí/2 to pí/2. (Returned value is data type float.)
    Sqrt(X) Returns square root of X. (Returned value is data type float.)
    Max(X,Y) Returns the greater number from X and Y.
    Min(X,Y) Returns the lesser number from X and Y.
    in(X, X1, X2, X3...) Returns True if the value X is equal to one of values X1,X2, X3.... (Returned value is data type boolean.)
    Log(X,Y) Returns logarithm of X with base Y. Number X is a positive real number. (Returned value is data type float.)
    Log10(X) Returns common (decadic) logarithm of X. X is positive real number. (Returned value is data type float.)
    Exp(X) Returns the base of the natural logarithm raised to the power of X. (Returned value is data type float.)
    Abs(X) Returns an absolute value of the input number. (Returned value is data type float.)

     

    In this article
    ×