8.4. VC Function References

The table below details the numerical functions currently implemented in VC. The unit of the angular values (inputs for trigonometric functions or outputs for inverse trigonometric functions) is degree.

FunctionIdArg1Arg2Return
Arg1 to the power of Arg2powFLOATFLOATFLOAT
random value between Arg1 and Arg2randFLOATFLOATFLOAT
maximal value of Arg1 and Arg2maxFLOATFLOATFLOAT
minimal value of Arg1 and Arg2minFLOATFLOATFLOAT
rounding Arg1 to nearest integerroundFLOATNoneINT
square root of Arg1sqrtFLOATNoneFLOAT
largest integral value not greater than Arg1floorFLOATNoneINT
cosine of Arg1cosFLOATNoneFLOAT
sine of Arg1sinFLOATNoneFLOAT
tangent of Arg1tanFLOATNoneFLOAT
inverse cosine of Arg1acosFLOATNoneFLOAT
inverse sine of Arg1asinFLOATNoneFLOAT
inverse tangent of Arg1atanFLOATNoneFLOAT
natural logarithm of Arg1logFLOATNoneFLOAT
absolute value of Arg1absFLOATNoneFLOAT
sign of Arg1 (+1 if >0, -1 if <0, O if null)signFLOATNoneFLOAT
inversion of Arg1invFLOAT or INT MATRIXNoneFLOAT or INT MATRIX
norm of Arg1normFLOAT or INT TABLENoneFLOAT

The following expression is an example of vector norm computation.

Equation 8-4. Expression with a vector norm computation

(norm({@root:test}))