Back | Forward

You might use a user-defined item to:

• Calculate the sum (or difference, product, or quotient) of two or more table items in the database, or the sum (or difference, product, or quotient) of table items in the database and one or more user-defined table items.

• Calculate a date or time which is a specified number of units (either a constant value or a value obtained from the FASuite database) from some other date or time.

• Form a string of characters by extracting some of the characters from a string table item, or by combining two or more string table items.

• Define a constant value to include in a query or report

• Select one of several constant values, depending on the value of a table item or user-defined item.