Specifications
CHAPTER 24 DataWindow Expression and InfoMaker Functions
Users Guide 741
Examples This expression for a computed field returns 10 spaces in the computed field if
the value of the rating column is Top Secret; otherwise, it returns the value in
rating:
If(rating = "Top Secret", Space(10), rating)
See also Fill
Sqrt
Description Calculates the square root of a number.
Syntax Sqrt ( n )
Return value
Double. Returns the square root of n.
Usage Sqrt(n) is the same as n ^.5.
Taking the square root of a negative number causes an execution error.
Examples This expression returns 1.414213562373095:
Sqrt(2)
This expression results in an error at execution time:
Sqrt(-2)
Argument Description
n The number for which you want the square root