Specifications

WordCap
760 InfoMaker
This expression returns the variance of the values in group 1 in the column
named salary:
VarP(salary for group 1)
This expression returns the variance of the values in column 4 on the page:
VarP(#4 for page)
This expression entered in the Value box on the Data property page in the
graph’s property sheet returns the variance of the values in the quantity column
in the graph:
VarP(quantity for graph)
This expression for a computed field in a crosstab returns the variance of the
values in the quantity column in the crosstab:
VarP(quantity for crosstab)
Assuming a report displays the order number, amount, and line items for each
order, this computed field returns the variance of the order amount for the
distinct order numbers:
VarP(order_amt for all DISTINCT order_nbr)
See also
StDevP
Var
WordCap
Description Sets the first letter of each word in a string to a capital letter and all other letters
to lowercase (for example, ROBERT E. LEE would be Robert E. Lee).
Syntax WordCap ( string )
Return value
String. Returns string with the first letter of each word set to uppercase and the
remaining letters lowercase if it succeeds, and null if an error occurs.
Examples This expression returns Boston, Massachusetts:
WordCap("boston, MASSACHUSETTS")
Argument Description
string A string or expression that evaluates to a string that you want to
display with initial capital letters (for example, Monday Morning)